Do you have an example of what you are doing, binary data and the needed output ?.

John
www.ideo.com

-----Original Message-----
From: Shelly Wu [mailto:[Email Address Removed] November 19, 2002 8:02 AM
To: LazyDBA.com Discussion
Subject: convert datatype from binary to hexadecimal


Hi List,

I want to convert a column from binary to hexadecimal.What is that function
name?

from binary to char(18),this char(18) should look like a
hexadecimal,'ox.......'.

The system will convert the binary to char automatically,but the format or
style is not beginning with '0x.....'.


Any help is appreciated here.

thanks

Shelly

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page