LCASE

A scalar string function that converts all uppercase letters in a string to lowercase letters.

Synopsis

{fn LCASE(string-expression)}

Arguments

string-expression

The string expression whose characters are to be converted to lower case. The expression can be the name of a column, a string literal, or the result of another scalar function, where the underlying data type can be represented as any character type (such as CHAR or VARCHAR).

Description

LCASE converts uppercase letters to lower case. It has no effects on non-alphabetic characters.

Examples

The following example returns each person's name in lowercase letters:

SELECT Name,{fn LCASE(Name)} AS LowName
     FROM Sample.Person

LCASE also works on Unicode (non-ASCII) alphabetic characters, as shown in the following embedded SQL example, which converts Greek letters from uppercase to lowercase:

   SET a=$CHAR(920)_$CHAR(913)_$CHAR(923)_$CHAR(913)_$CHAR(931)_$CHAR(913)
   &sql(SELECT {fn LCASE(:a)}
   INTO :b
   FROM Sample.Person)
   WRITE !,a,!,b