Post reply

function to convert varbinary datatype to char or

  • September 25, 2003 at 2:03 am

    #81161

    hai ,

    can any one suggest a function to convert varbinary datatype to char or Varchar data type .

  • September 25, 2003 at 2:58 am

    #475746

    convert and cast will do it.

  • September 26, 2003 at 12:22 pm

    #476065

    If you want to convert the varbinary data to a hexadecimal string (like how it gets displayed in Query Analyzer by default), you can use the built-in function master.dbo.fn_varbintohexstr(). I have used this for outputting timestamp columns in XML.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply