Difference between revisions of "LOWER()"
From Lianjapedia
Helen.george (Talk | contribs) |
Barrymavin (Talk | contribs) m |
||
Line 14: | Line 14: | ||
<code lang="recital"> | <code lang="recital"> | ||
? lower("Lianja") | ? lower("Lianja") | ||
− | + | lianja | |
// Another Example | // Another Example |
Revision as of 23:18, 28 April 2014
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") lianja // Another Example use accounts index on lower(company) to company replace company with "Company Name" seek "company name" ? found() .T.