SQL - Convert Hex To VarBinary To Int

---Convert Hex To VarBinary To Int

-- If the '0x' marker is present:

SELECT CONVERT(INT, CONVERT(VARBINARY, '0x1FFFFF', 1))

-- If the '0x' marker is NOT present:

SELECT CONVERT(INT, CONVERT(VARBINARY, '1FFFFF', 2))

--Hexadecimal

'4001802D'

--Convert Hexadecimal Into Hexadecimal Varbinary (eg.0x4001802D)

SELECT CONVERT(VARBINARY, '0x4001802D', 1)

SELECT CONVERT(VARBINARY, '4001802D', 2)

--Convert Hexadecimal Varbinary Into Integer (Binary In Decimal/Int) (eg.1073840173)

SELECT CONVERT(INT, convert(VARBINARY, '4001802D', 2))