A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  special characters  sybase-tech-blog


Category: ASE: Functions: Datatype Conversion Functions

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().