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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply