LOWER()

Syntax

Output_String as C = LOWER( Input_String as C )

Argument	Description
Input_String	A character string.

Description

LOWER() converts the specified character string to lowercase.

Supported By

Alpha Five Version 5 and Above

Examples

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.