varbinary to string

0

Please login or register to vote for this query.

(click on this box to dismiss)

Psychology and Neuroscience Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

declare @b varbinary(255)
set @b = 0x63e34686fda198f2fe0bc790d90d6e89f622e4f2c342c2840a5a4c2d985cbd45e36d62f645e9f6d409c8c4b5acc8452e109584bd8b937d96063b76bb6c2c9986a201b9fbc6ecba29522079408f217344

select cast(@b as varbinary(255)) /*Returns "This is a test"*/

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results