Posted by Erland Sommarskog on 12/22/06 14:09

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: Script to combine multiple rows into 1 single row
• Prev in forum: Re: Stored Procedure Range Not Working
• Thread view: Re: How to search binary fields?

[Reply to this message]