Difference between revisions of "LOWER()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
m (Text replace - "Recital" to "Lianja") |
||
Line 13: | Line 13: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
− | ? lower(" | + | ? lower("Lianja") |
recital | recital | ||
Revision as of 22:26, 7 December 2012
Contents
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("Lianja") recital // Another Example use accounts index on lower(company) to company replace company with "Company Name" seek "company name" ? found() .T.