pcgym
asked on
How do I convert Binary to Text in SQL Server?
I am querying a Goldmine database and need to convert Goldmine..Notes.Notes from Binary Image to Text.
Here is a sample of what the field is storing '0x342F3520492063616C6C656 420746F206 66F6C6C6F7 7207570206 F6E2066616 9727669657 7206C65747 4657220736 56E7420746 F207265697 4726565732 E204C45465 4204D53472 E203C62723 E3C62723E5 4686520706 86F6E65206 E756D62657 2207765206 8617665206 C697374656 4206D61792 06E6F74206 26520636F7 2726563742 E204E6F206 C697374696 E6720696E2 0717765737 46465782E3 C62723E00'
Here is a sample of what the field is storing '0x342F3520492063616C6C656
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.