Difference between revisions of "LOWER()"

Revision as of 15:53, 2 June 2009

Class

String Data

Purpose

Function to convert characters to lower case

Syntax

LOWER(<expC>)

See Also

ISLOWER(), ISUPPER(), PROPER(), STRTRAN(), TRANSFORM(), UPPER()

Description

The LOWER() function converts the characters in the character expression <expC> to lower case. This function is particularly useful if used in index keys and their corresponding SEEK expressions, since a search expression in lower case will match both upper and lower case characters.

Example

? lower("Recital")
recital
 
// Another Example
use accounts
index on lower(company) to company
replace company with "Company Name"
seek "company name"
? found()
.T.

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer