Ok I've been trying and trying but can't figure it out.

I have a SQL 6.5 database that I need to run SQL statements searching a binary field which contains GUIDs. Now, before I run the query I have the string value of the GUID, for example "BC713507-8AB8-11D2-B4A9-0008C7FA5601".

Obviously I can't use that and get results so I need to convert it to the binary value first but I don't know how to in VB6.

If only this were SQL 7 then I could do it easily.

Please help!