Post reply

Convert string Hex to Numeric with inline TSQL

  • November 8, 2011 at 8:04 pm

    #250529

    Comments posted to this topic are about the item Convert string Hex to Numeric with inline TSQL

  • August 8, 2012 at 8:11 am

    #1523132

    A faster way to convert Hex to Dec is

    select CAST(CONVERT(VARBINARY, 'FF00FF', 2) AS INT)

    The string to convert must be at least 2 chars long :

    select CAST(CONVERT(VARBINARY, 'F', 2) AS INT) : error

    select CAST(CONVERT(VARBINARY, '0F', 2) AS INT) : 15

  • December 17, 2012 at 7:08 am

    #1569136

    To convert fast from INT to HEX :

    right(master.dbo.fn_varbintohexstr(cast( Disconnection_cause as INT) ),2)

  • January 18, 2013 at 4:09 am

    #1578626

    Federico Iori (8/8/2012)

    A faster way to convert Hex to Dec is

    select CAST(CONVERT(VARBINARY, 'FF00FF', 2) AS INT)

    The string to convert must be at least 2 chars long :

    select CAST(CONVERT(VARBINARY, 'F', 2) AS INT) : error

    select CAST(CONVERT(VARBINARY, '0F', 2) AS INT) : 15

    the faster and faster:

    select CONVERT(VARBINARY, 'fffe', 2)+0 --implicit cast

  • May 2, 2016 at 4:20 pm

    #1876117

    Thanks for the script.

Viewing 5 posts - 1 through 4 (of 4 total)

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