Difference between revisions of "STRTOLOWER()"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
Line 29: | Line 29: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | |||
[[Category:String Data Functions]] | [[Category:String Data Functions]] |
Revision as of 06:56, 4 February 2013
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") recital // Another Example use accounts index on strtolower(company) to company replace company with "Company Name" seek "company name" ? found() .T.
Products
Lianja Server, Lianja