Converting Filestream to varchar/xml

• SqlServerNinja

  Ten Centuries

  Points: 1238

  More actions

  April 11, 2013 at 8:05 am

  #270956

  Hello everyone,

  We have an xml that has been converted into a filestream format

  and stored into a column of a table.

  I now have to extract some of the data from the xml

  So I would like to know if there is a way of converting a fiestream datatype (varbinary(max) Filestream)

  into a varchar or xml datatype ?

• SqlServerNinja

  Ten Centuries

  Points: 1238

  More actions

  April 11, 2013 at 8:16 am

  #1605598

  Hey I found a solution that works !

  select top 1 CONVERT(varchar(1000), FilestreamcolumnName, 0) from Tablename;

  This was easy.

  Please do let me know if you think there is a better way to do it.