I have a binary field in the table. It's value is 0xB3C54EFB6C02017046905007293650B1.
However, when I try this:
DECLARE @MD5 Binary
SET @MD5=0xB3C54EFB6C02017046905007293650B1
SELECT * FROM MyTable WHERE MyTable.MD5=@MD5
...it doesn't find the record.
This is a syntax issue. Anyone would know what I am missing?