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?