Sybase Adaptive Server Anywhere - Page 360

Alphabetical list of functions
342
string-expression-1 The string into which the other string is to be
inserted.
string-expression-2 The string to be inserted.
The following statement returns the value backoffice.
SELECT INSERTSTR( 0, ’office ’, ’back’ )
♦ SQL/92 Vendor extension.
♦
Sybase Not supported in Adaptive Server Enterprise.
"STUFF function" on page 368
INTTOHEX function [Data type conversion]
Returns a string containing the hexadecimal equivalent of an integer.
INTTOHEX ( integer-expression )
integer expression The integer to be converted to hexadecimal.
The following statement returns the value 9c:
SELECT INTTOHEX( 156 )
♦ SQL/92 Transact-SQL extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
"HEXTOINT function" on page 339
ISNULL function [Miscellaneous]
Returns the first non-NULL expression in the parameter list.
ISNULL ( expression , expression [ , ... ] )
expression An expression to be tested against NULL.
At least two expressions must be passed into the function.
The following statement returns the value -66.
SELECT ISNULL( NULL ,-66, 55, 45, NULL, 16 )
♦ SQL/92 Transact-SQL extension.
♦
Sybase Compatible with Adaptive Server Enterprise, except that
Adaptive Server Enterprise allows only two expressions.
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility