Friday, September 17, 2010

How To Alter image DataType to varchar?

it is not possible to convert image data type to varchar. To use image datatype column to as a string So you 
can Alter image to varBinary with some limitation.
Query
alter Table Tbl_Suppliers
alter column ProfileImage Varbinary