Chapter 8 SQL Functions
343
"COALESCE function" on page 320
LCASE function [String]
Converts all characters in a string to lower case.
LCASE (
string-expression
)
string-expression The string to be converted to lower case.
The following statement returns the value lower case.
SELECT LCASE( ’LOWER CasE’ )
♦ SQL/92 Vendor extension.
♦
Sybase LCASE is not supported in Adaptive Server Enterprise; you
can use LOWER to get the same functionality.
"LOWER function" on page 346
"UCASE function" on page 373
"UPPER function" on page 374
LEFT function [String]
Returns a number of characters from the beginning of a string.
LEFT (
string-expression
,
integer-expression
)
string-expression The string.
integer-expression The number of characters to return.
The following statement returns the value choco.
SELECT LEFT( ’chocolate’, 5 )
If the string contains multi-byte characters, and the proper collation is being
used, the number of bytes returned may be greater than the specified number
of characters.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
"RIGHT function" on page 362
"International Languages and Character Sets" on page 287 of the book ASA
User’s Guide
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Usage
Standards and
compatibility
See also
To Next Page
Loading...