Convert from Decimal to Hex in SQL

See this example

Convert INT to hex:

SELECT CONVERT(VARBINARY(8), 16777215)

Please try the above with a bigger length.

Many Thanks & Best Regards, Hua Min