INTTOHEX( integer-expression )

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.

• HEXTOINT function [Data type conversion]

The following statement returns the value 0000009c.

SELECT INTTOHEX( 156 );