April 25, 2017 at 11:31 am
We have a third party database and most of the values are in varbinary(max).
How do I evaluate those values into standard text?
How do I see the values stored in binary text?
How do I see the meaning of the binary value?
April 25, 2017 at 11:49 am
scott.laird - Tuesday, April 25, 2017 11:31 AMWe have a third party database and most of the values are in varbinary(max).How do I evaluate those values into standard text?
How do I see the values stored in binary text?
How do I see the meaning of the binary value?
Use the convert (function)
😎
April 25, 2017 at 3:40 pm
If CONVERT doesn't work, then the data may not be of the type you think it is, or, it could be encrypted. Just guessing since we can't see what's going on.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply