The default output is varbinary:0x86FB269D190D2C85F6E0468CECA42A20
But I need it as char(32):86FB269D190D2C85F6E0468CECA42A20
Does anyone know how to do this? I can't use the varbinary data type in my application. I can only use char(32) datatype. Thanks.
Your original message is getting old; did you find that the answer is to use the master.dbo.fn_varbintohexstr function?