Convert in sql server

Question

Can any budy tell me how to convert varbinay to String in sql server 2008. Ex:0x0100AE057C68FB900180D82212F37F2473C566696D9E4AB920C2FB900180D82212F37F2473C566696D9E4AB920C2 i want to Show its orginal text.

Abhishek Goswami · Answer

check this ... @ varBinry= 0x0100AE057C68FB900180D82212F37F2473C566696D9E4AB920C2FB900180D82212F3 SELECT CONVERT ( varchar ( max )@ varBinry  2 )

Jignesh Trivedi · Answer

hi using cast and convert function you can do casting from one data type to other. refer http://msdn.microsoft.com/en-us/library/ms187928.aspx hope this will help you.

Raju parmar · Answer

Convert(varchar(max)'Yr code'2)