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 30, 2010 at 2:38 am

    #1186922

    DECLARE @test-2 AS VARBINARY(MAX)

    SET @test-2 = 0x4858FE25053CA4D236F3D61AE29668BA

    SELECT @test-2

    ,Substring(( MASTER.dbo.Fn_varbintohexstr(@test) ), 1, 2) +

    Substring(Upper(MASTER.dbo.Fn_varbintohexstr(@test)), 3, 8000)

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/