Trang Bartell

Trang Bartell

  • 1.7k
  • 52
  • 1.4k

How to handle SQL Server IMAGE data type as TEXT data type

Dec 14 2020 9:24 AM
Hello, I'm learning to migrate an old application that has tables with coumns defined as IMAGE data type which were used to store text comments.  I need help with the following, please:
 
Either:
 
1. How to convert the data from IMAGE data type to TEXT data type
 
Or:
 
2. How to retrieve the data from IMAGE data type and display as Text and Update/Insert back into the database. 
 
Thanks in advance for your help. 

Answers (2)