A case-transformation function that converts all uppercase letters in a string to lowercase letters.
SELECT TOP 10 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:
IF $SYSTEM.Version.IsUnicode() {
SET a=$CHAR(920,913,923,913,931,931,913)
&sql(SELECT LCASE(:a) INTO :b )
IF SQLCODE'=0 {
WRITE !,"Error code ",SQLCODE }
ELSE {WRITE !,a,!,b }
}
ELSE {WRITE "This example requires a Unicode installation of Caché"}