Solved

How do I convert Binary to Text in SQL Server?

Posted on 2011-09-12
1
696 Views
Last Modified: 2012-05-12
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 '0x342F3520492063616C6C656420746F20666F6C6C6F77207570206F6E206661697276696577206C65747465722073656E7420746F2072656974726565732E204C454654204D53472E203C62723E3C62723E5468652070686F6E65206E756D6265722077652068617665206C6973746564206D6179206E6F7420626520636F72726563742E204E6F206C697374696E6720696E2071776573746465782E3C62723E00'

0
Comment
Question by:pcgym
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 11

Accepted Solution

by:
stevengraff earned 500 total points
ID: 36523405
try:

cast(cast(notes as varbinary(max))as varchar(max))

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL query for highest sequence 4 63
SQL Job Hung 17 37
SQL server client app 3 31
T-SQL: Need a database plan to mine a pretty big Log table 4 22
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question