Returns a string containing the hexadecimal equivalent of an integer.

The CAST, CONVERT, HEXTOINT, and INTTOHEX functions can be used to convert to and from hexadecimal values. For more information on using these functions, see Converting to and from hexadecimal values.

Syntax

INTTOHEX( integer-expression )

Parameters

See also

• HEXTOINT function [Data type conversion]

Standards and compatibility

Example

The following statement returns the value 0000009c.

SELECT INTTOHEX( 156 );