Difference between revisions of "LOWER()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to convert characters to lower case | Function to convert characters to lower case | ||
| Line 8: | Line 4: | ||
==Syntax== | ==Syntax== | ||
| − | LOWER(<expC>) | + | LOWER(<expC> | <memofield>) |
==See Also== | ==See Also== | ||
| − | [[ISLOWER()]], [[ISUPPER()]], [[PROPER()]], [[STRTOLOWER()]], [[STRTOUPPER()]], [[STRTRAN()]], [[TRANSFORM()]], [[UPPER()]] | + | [[ISLOWER()]], [[ISUPPER()]], [[PROPER()]], [[SET STRESCAPE]], [[STRTOLOWER()]], [[STRTOUPPER()]], [[STRTRAN()]], [[TRANSFORM()]], [[UPPER()]] |
==Description== | ==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. | + | 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. |
Latest revision as of 13:23, 21 July 2010
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
