Home Forums SQL Server 2005 T-SQL (SS2K5) Getting the VARBINARY data into a VARCHAR field RE: Getting the VARBINARY data into a VARCHAR field

  • June 13, 2016 at 10:50 am

    #1884720

    Sorry to revive this topic, but I have a same issue but neither CONVERT (VARCHAR(MAX)... nor master.dbo.fn_varbintohexstr worked for me.

    two examples I have in SQL:

    0x24005472616E73616374696F6E2046656520666F7220466C6967687420506167652020202031

    I know it means "Transaction Fee for Flight Page 1 "

    0x2A004164646F6E205472616E73616374696F6E2046656520666F7220466C6967687420506167652020202031

    meaning "Addon Transaction Fee for Flight Page 1 "

    the translations are from an old DOS based program, which used to write into SQL in the past.

    Can anyone advise what else I can use, please?