has_role  hextoint

Chapter 2: Transact-SQL Functions

hextobigint

Description

Returns the bigint value equivalent of a hexadecimal string

Syntax

hextobigint (hexadecimal_string)

Parameters

hexadecimal_string

is the hexadecimal value to be converted to an big integer; must be a character-type column, variable name, or a valid hexadecimal string, with or without a “0x” prefix, enclosed in quotes.

Examples

Example 1

The following example converts the hexadecimal string 0x7fffffffffffffff to a big integer.

1> select hextobigint("0x7fffffffffffffff")
2> go
--------------------
9223372036854775807

Usage

See also

Functions biginttohex, convert, inttohex, hextoint





Copyright © 2005. Sybase Inc. All rights reserved. hextoint

View this book as PDF