STRTOLOWER()
From Lianjapedia
Revision as of 13:43, 19 May 2014 by Yvonne.milne (Talk | contribs)
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.