Posted by Hugo Kornelis on 05/01/07 21:39

On 1 May 2007 11:26:58 -0700, tfeller wrote:

>I would like to drop the leading 0x on a binary value so I can do a
>bitwise operation.
>
>Here is simplified code:
>
>select right(0x88186000,8)
>
>I expected to get back 88186000, this was not the case. The command
>returned some wierd characters.
>
>Am I missing something?

Hi tfeller,

Maybe the functions Peter DeBetta describes will help you to achieve
what you need:
http://sqlblog.com/blogs/peter_debetta/archive/2007/03/09/t-sql-convert-hex-string-to-varbinary.aspx

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

• Next in forum: Re: Dynamic SQL reading statements from table
• Prev in forum: Re: Dynamic SQL reading statements from table
• Thread view: Re: Binary Value Manipulation

[Reply to this message]