LOWER()
From Recital Documentation Wiki
Revision as of 12:03, 23 March 2009 by Yvonnemilne (Talk | contribs)
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