Difference between revisions of "STRTOLOWER()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Yvonne.milne (Talk | contribs) |
||
(2 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to convert characters to lower case | Function to convert characters to lower case | ||
− | |||
==Syntax== | ==Syntax== | ||
STRTOLOWER(<expC>) | STRTOLOWER(<expC>) | ||
− | |||
==See Also== | ==See Also== | ||
[[ISLOWER()]], [[ISUPPER()]], [[LOWER()]], [[PROPER()]], [[SET STRESCAPE]], [[STRTOUPPER()]], [[STRTRAN()]], [[TRANSFORM()]], [[UPPER()]] | [[ISLOWER()]], [[ISUPPER()]], [[LOWER()]], [[PROPER()]], [[SET STRESCAPE]], [[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. | 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("Lianja") | ? strtolower("Lianja") | ||
− | + | lianja | |
// Another Example | // Another Example | ||
Line 29: | Line 25: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | |||
[[Category:String Data Functions]] | [[Category:String Data Functions]] |
Latest revision as of 13:43, 19 May 2014
Contents
Purpose
Function to convert characters to lower case
Syntax
STRTOLOWER(<expC>)
See Also
ISLOWER(), ISUPPER(), LOWER(), PROPER(), SET STRESCAPE, 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("Lianja") lianja // Another Example use accounts index on strtolower(company) to company replace company with "Company Name" seek "company name" ? found() .T.