Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

INTTOHEX function [Data type conversion]

Returns a string containing the hexadecimal equivalent of an integer.

INTTOHEX( integer-expression )

integer-expression    The integer to be converted to hexadecimal.

• HEXTOINT function [Data type conversion]

• SQL/2003    Transact-SQL extension.

The following statement returns the value 0000009c.

SELECT INTTOHEX( 156 );