SQLTeam.com | Weblogs | Forums

Convert emage datatype to text or varchar datatype


Hi all, I need to convert a emage datatype to a readable format. I am using this:

Select CONVERT(varchar(1000), convert(varbinary(1000), filedata)) From [dbo].[arm_arf_orig], it works but the result is some weired char. Can somebody please help? Thanks in advance!


I don't think you can do this with SQL Server alone. I believe you'll need to write an app to read the image data and then put the converted data back into the database in a different column.