LOWER()

From Recital Documentation Wiki
Revision as of 13:23, 21 July 2010 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to convert characters to lower case


Syntax

LOWER(<expC> | <memofield>)


See Also

ISLOWER(), ISUPPER(), PROPER(), SET STRESCAPE, STRTOLOWER(), STRTOUPPER(), STRTRAN(), TRANSFORM(), UPPER()


Description

The LOWER() function converts the characters in the character expression <expC> or memo <memofield> 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 Server, Recital