Two new functions support the explicit conversion of hexadecimal to big integer data and big integer to hexadecimal data.The HEXTOBIGINT function accepts hexadecimal integers and returns the BIGINT data type equivalent. The BIGINTTOHEX function accepts an integer expression that evaluates to BIGINT and returns the hexadecimal equivalent as VARCHAR(16) data type.
For more information on these data type conversion functions, see “HEXTOBIGINT function [Data type conversion]” and “BIGINTTOHEX function [Data type conversion]” in Chapter 5, “SQL Functions” in the Sybase IQ Reference Manual.
