C# string data and SQL 2000 binary data
I have a string-representation of a GUID being passed into my c# web service, and I want to look this value up in my SQL 2000 table. However, my GUIDS in the database are stored as binary. How can I compare these two values to find a match in the table? I tried SQL convert, cast, but they didn't work. Are there any C# conversion functions I can use? The two values I would like to compare look similar to:
string GUID: 9F1F7BF37997604DB88249E9FFB2AD66 -- in C#
binary GUID: 0x9F1F7BF37997604DB88249E9FFB2AD66 -- in DB
Many thanks!
Aaron