Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Stephen Lasham Converting Hexadecimal String Values to Alpha (ASCII) Strings RE: Converting Hexadecimal String Values to Alpha (ASCII) Strings

  • May 16, 2007 at 11:14 pm

    #707008

    did you try

    select

    cast(cast(0x416E6E61737461736961 as varbinary) as varchar)

    ?

     

    /R