>declare @Tmp table >( Id int IDENTITY(1,1) NOT NULL, > MD5 binary(16) not null >); > >insert into @Tmp (MD5) values (0xB3C54EFB6C02017046905007293650B1); >insert into @Tmp (MD5) values (0xB3C54EFB6C02017046905007293650B2); > >declare @MD5 Binary(16); >SET @MD5 = 0xB3C54EFB6C02017046905007293650B2; > > >select * from @Tmp where (MD5 = @MD5); >If I put 0x + loDataParameterSQLClient.Value, it will end up with 0xSystem.Byte[].