Difference between revisions of "STRTOLOWER()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
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== | ||
Line 28: | Line 24: | ||
.T. | .T. | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== |
Revision as of 10:15, 12 December 2012
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