Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lenovo27
Starting Member
15 Posts |
 Posted - 2009-11-09 : 17:54:42
|
| I have to extract information from an SQL database. Part of the information I want is stored in a column which has a datatype of MICBIND:varbinary(18). Changing the datatype to string just brings back chinese characters or something.I found instructions on how to use an SQL function but all that did is display the information in the column as hexstring 0X23L43K43A3D35F902R3DJF9 instead of the <binary> it displayed before.What I want to do is see what the information in that column actually says. For example, if one of the rows has a value of "All", I want to be able to see that.Any ideas?I tried the following function but didn't get any further than what I just posted.SELECT sys.fn_sqlvarbasetostr(MD5Hash) From HashTable |
|
|
|
|
|
How to change MICBIND:varbinary(18) to string?