Forum Replies Created

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

  • RE: SQL Server - Convert HEX value to ASCII value

    sgmunson - Thursday, November 30, 2017 10:12 AM

    Here's how:
    DECLARE @HEX_VALUE AS varchar(100) = '刀椀瘀攀爀猀椀搀攀'

    SELECT CONVERT(varchar(20),
        (
        SELECT CHAR(TRY_CONVERT(int, TRY_CONVERT(varbinary, S.Item, 1)))
        FROM dbo.DelimitedSplit8K(REPLACE(REPLACE(@HEX_VALUE, '00', ''),...

    December 1, 2017 at 2:52 am

    #1970234

  • RE: SQL Server - Convert HEX value to ASCII value

    John Mitchell-245523 - Thursday, November 30, 2017 9:32 AM

    Search this site for a splitter function to split the string into individual elements. ...

    December 1, 2017 at 2:52 am

    #1970233

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