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
MS Sql Server LazyDBA home page