ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

HEXTOINT function [Data type conversion]

Function 

Returns the decimal integer equivalent of a hexadecimal string.

Syntax 

HEXTOINT ( hexadecimal-string )

Parameters 

hexadecimal-string    The string to be converted to an integer.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

INTTOHEX function [Data type conversion]

Example 

The following statement returns the value 420.

SELECT HEXTOINT ( '1A4' )