You didn't specify the size in DECLARE statement for @MD5
>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?
--sb--