ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

INTTOHEX function [Data type conversion]

Function 

Returns a string containing the hexadecimal equivalent of an integer.

Syntax 

INTTOHEX ( integer-expression )

Parameters 

integer expression    The integer to be converted to hexadecimal.

Standards and compatibility 

• SQL/92    Transact-SQL extension.

• SQL/99    Transact-SQL extension.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

HEXTOINT function [Data type conversion]

Example 

The following statement returns the value 9c:

SELECT INTTOHEX( 156 )