varbinary to string

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results