Returns a string containing the hexadecimal equivalent of an integer.
INTTOHEX( integer-expression )
integer-expression The integer to be converted to hexadecimal.
VARCHAR
The CAST, CONVERT, HEXTOINT, and INTTOHEX functions can be used to convert to and from hexadecimal values. For more information, see Converting to and from hexadecimal values.
SQL/2008 Vendor extension.
The following statement returns the value 0000009c.
SELECT INTTOHEX( 156 );