Output_String as C = LOWER( Input_String as C )
A character string.
LOWER() converts the specified character string to lowercase.
Alpha Five Version 5 and Above
lower(FIRSTNAME) -> "beverly", if FIRSTNAME contains "BEVERLY"
You often need to perform case insensitive searches of your table. Assume that you want to search the COMPANY field for all the records that have the string "computer" anywhere in the field. Records like "Computers Without Fear," "THE COMPUTER STORE," "The COMPUTERshop," and so on should be found. The following filter expression would work:
"computer" $ lower(COMPANY)
The LOWER() function converts all the data in COMPANY to lowercase, and the $ operator looks for any occurrence of the lowercase string "computer" anywhere within COMPANY.
Character Case Functions