Convert string Hex to Numeric with inline TSQL

• Federico Iori

  SSCommitted

  Points: 1625

  More actions

  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

• Federico Iori

  SSCommitted

  Points: 1625

  More actions

  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

• Federico Iori

  SSCommitted

  Points: 1625

  More actions

  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)

• Carlo Romagnano

  SSC-Insane

  Points: 21965

  More actions

  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

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 2, 2016 at 4:20 pm

  #1876117

  Thanks for the script.