Sybase Adaptive Server Anywhere - Page 363

Chapter 8 SQL Functions
345
NULL values are not added to the list. List(X) returns the concatenation
(with delimiters) of all the non-NULL values of X for each row in the group.
If there does not exist at least one row in the group with a definite X-value,
then LIST(X) returns the empty string.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported in Adaptive Server Enterprise.
LOCATE function [String]
Returns the position of one string within another.
LOCATE ( string-expression-1 , string-expression-2 [, integer-expression ] )
string-expression-1 The string to be searched.
string-expression-2 The string to be searched for. This string is limited
to 255 bytes.
integer-expression The character position in the string to begin the
search. The first character is position 1.
The following statement returns the value 8.
SELECT LOCATE( 'office party this week – rsvp as soon as
possible', 'party', 2 )
If integer-expression is specified, the search starts at that offset into the
string.
The first string can be a long string (longer than 255 bytes), but the second is
limited to 255 bytes. If a long string is given as the second argument, the
function returns a NULL value. If the string is not found, 0 is returned.
Searching for a zero-length string will return 1. If any of the arguments are
NULL, the result is NULL.
If multi-byte characters are used, with the appropriate collation, then the
starting position and the return value may be different from the byte
positions.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
LOG function [Numeric]
Returns the natural logarithm of a number.
Usage
Standards and
compatibility
Function
Syntax
Parameters
Examples
Usage
Standards and
compatibility
Function