Difference between revisions of "STRTOLOWER()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
==Class== | ==Class== | ||
| − | + | String Data | |
==Purpose== | ==Purpose== | ||
| − | + | Function to convert characters to lower case | |
==Syntax== | ==Syntax== | ||
| − | + | STRTOLOWER(<expC>) | |
==See Also== | ==See Also== | ||
| − | + | [[ISLOWER()]], [[ISUPPER()]], [[LOWER()]], [[PROPER()]], [[STRTOUPPER()]], [[STRTRAN()]], [[TRANSFORM()]], [[UPPER()]] | |
==Description== | ==Description== | ||
| − | + | The STRTOLOWER() 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== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| + | ? strtolower("Recital") | ||
| + | recital | ||
| + | // Another Example | ||
| + | use accounts | ||
| + | index on strtolower(company) to company | ||
| + | replace company with "Company Name" | ||
| + | seek "company name" | ||
| + | ? found() | ||
| + | .T. | ||
</code> | </code> | ||
| − | |||
| + | ==Products== | ||
| + | Recital Server, Recital | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:String Data]] | ||
| + | [[Category:String Data Functions]] | ||
Revision as of 11:12, 13 October 2009
Class
String Data
Purpose
Function to convert characters to lower case
Syntax
STRTOLOWER(<expC>)
See Also
ISLOWER(), ISUPPER(), LOWER(), PROPER(), STRTOUPPER(), STRTRAN(), TRANSFORM(), UPPER()
Description
The STRTOLOWER() 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
? strtolower("Recital") recital // Another Example use accounts index on strtolower(company) to company replace company with "Company Name" seek "company name" ? found() .T.
Products
Recital Server, Recital
