|
hextoint()
The
Datatype Conversion Function
hextoint()
returns the number for a platform specific hexadecimal value.
Syntax of the Datatype Conversion Function hextoint()
hextoint( hexadecimal_string )
The parameter of the Datatype Conversion Function hextoint()
hexadecimal_string
The parameter "hexadecimal_string" is a placeholder for its platform dependent hexadecimal equivalent of an integer number. The parameter can be used with the optional prefix "0x".
The return value is the corresponding integer number.
Example for the Datatype Conversion Function hextoint()
select hextoint("1f40")
go
-----
8000
or
select hextoint("0x1f40")
go
-----
8000
See also:
ASE T-SQL - Aggregate Functions, biginttohex(), bintostr(), cast(), convert(), Datatype Conversion Functions, explicit conversion, hextobigint(), implicit conversions, inttohex().
|