HEXTOINT function [Data type conversion]

Function

Returns the unsigned BIGINT equivalent of a hexadecimal string.

Syntax

HEXTOINT ( hexadecimal-string )

Parameters

hexadecimal-string The string to be converted to an integer. Input can be in the following forms, with either a lowercase or uppercase “x” in the prefix, or no prefix:

0xhex-string
0Xhex-string
hex-string

Examples

The following statements return the value 420:

SELECT HEXTOINT ( '0x1A4' ) FROM iq_dummy
SELECT HEXTOINT ( '0X1A4' ) FROM iq_dummy
SELECT HEXTOINT ( '1A4' ) FROM iq_dummy

Usage

For invalid hexadecimal input, Sybase IQ returns an error unless the CONVERSION_ERROR option is set to OFF. When CONVERSION_ERROR is OFF, invalid hexadecimal input returns NULL.

The database option ASE_FUNCTION_BEHAVIOR specifies that output of Sybase IQ functions, including INTTOHEX and HEXTOINT, is consistent with the output of Adaptive Server Enterprise functions. When the ASE_FUNCTION_BEHAVIOR option is enabled (the value is ON):

Standards and compatibility

See also

“ASE_FUNCTION_BEHAVIOR option”

“CONVERSION_ERROR option [TSQL]”

“INTTOHEX function [Data type conversion]”