Sybase Adaptive Server Anywhere - Page 338

Alphabetical list of functions
320
emp_lname Emp_fname
Klobucher James
Kuo Felicia
Kelly Moira
The position of the first character in the string being searched is 1.
If the string being searched contains more than one instance of the other
string, then CHARINDEX returns the position of the first instance.
If the string being searched does not contain the other string, then
CHARINDEX returns 0.
♦
SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
"SUBSTRING function" on page 369
CHAR_LENGTH function [String]
Returns the number of characters in a string.
CHAR_LENGTH ( string-expression )
string-expression The string whose length is to be calculated.
Trailing white space characters are included in the length returned.
The return value of a NULL string is NULL.
If the string is in a multi-byte character set, the CHAR_LENGTH value
differs from the number of bytes returned by BYTE_LENGTH.
The following statement returns the value 8.
SELECT CHAR_LENGTH( ’Chemical’ )
♦ SQL/92 This function is SQL/92 compatible.
♦
Sybase Compatible with Adaptive Server Enterprise.
"BYTE_LENGTH function" on page 316
COALESCE function [Miscellaneous]
Returns the first non-NULL expression from a list.
Usage
Standards and
compatibility
See also
Function
Syntax
Parameters
Usage
Examples
Standards and
compatibility
See also
Function