Posted by Mintyman on 01/03/07 11:44

Hi Erland,

Apologies for the delay in responding. I have been on Christmas break.

Thanks for helping me out with this one!

Mintyman

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns98A19A1BF4C6Yazorman@127.0.0.1...
> Mintyman (mintyman@ntlworld.com) writes:
>> The query i'm using is:
>>
>> select * from _COMPANY where Company_Id = convert(varbinary,
>> '0x00C0000000003B86')
>
> I would have preferred to see the underlying table definition, to be
> sure what the data type is. But assuming that it is binary, this should
> work:
>
> select * from _COMPANY where Company_Id = 0x00C0000000003B86
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: argue why sql2005
• Prev in forum: Re: argue why sql2005
• Thread view: Re: How to search binary fields?

[Reply to this message]