LAST_VALUE function [Aggregate]  LEFT function [String]

Chapter 4: SQL Functions

LCASE function [String]

Function

Converts all characters in a string to lowercase.

Syntax

LCASE ( string-expression )

Parameters

string-expression The string to be converted to lowercase.

NoteThe result data type 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 data type and size.

See “REPLACE function [String]” for more information.

Example

The following statement returns the value “lower case”:

SELECT LCASE( 'LOWER CasE' ) FROM iq_dummy

Standards and compatibility

See also

“LOWER function [String]”

“UCASE function [String]”

“UPPER function [String]”




Copyright © 2009. Sybase Inc. All rights reserved. LEFT function [String]

View this document as PDF