![ISNUMERIC function [Miscellaneous]](arrow-left.gif){kind=icon}
![LEFT function [String]](arrow-right.gif){kind=icon}
Converts all characters in a string to lowercase.
LCASE ( string-expression )
string-expression The string to be converted to lowercase.
The
result datatype of an LCASE function is a LONG
VARCHAR. If you use LCASE in a SELECT
INTO statement, you must have a Large Objects Management
option license or use CAST and set LCASE to
the correct datatype and size.
See “REPLACE function [String]” for more information.
The following statement returns the value “lower case”:
SELECT LCASE( 'LOWER CasE' ) FROM iq_dummy
Sybase LCASE is not supported in Adaptive Server Enterprise; you can use LOWER to get the same functionality.
