Home Forums Article Discussions Article Discussions by Author Discuss content posted by fediori Convert string Hex to Numeric with inline TSQL RE: Convert string Hex to Numeric with inline TSQL

  • 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