I have a hashbytes program that runs fine. If I print the hashbytes('md5',@string) to screen, it is perfect. I need to capture this value to put in a column via update. I want to store the value as it looks on the screen..character, not binary. But this output IS binary and generally looks like: 0xFIWEHTO83290JF92JSU2940J2FIWEHTO. I want to capture this AS CHARACTERS "FIWEHTO83290JF92JSU2940J2FIWEHTO" to save in a c(32) column. Thoughts?

I was not aware HASHBYTES function could return other characters than 0-9 and a-f.

I was looking for the same.
I found this solution from http://stackoverflow.com/questions/2...tes-to-varchar