Difference between revisions of "STRTOLOWER()"

From Lianjapedia
Jump to: navigation, search
m (1 revision)
m (Text replace - "Recital" to "Lianja")
Line 17: Line 17:
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
? strtolower("Recital")
+
? strtolower("Lianja")
 
recital
 
recital
  
Line 31: Line 31:
  
 
==Products==
 
==Products==
Recital Server, Recital
+
Lianja Server, Lianja
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:String Data]]
 
[[Category:String Data]]
 
[[Category:String Data Functions]]
 
[[Category:String Data Functions]]

Revision as of 01:25, 9 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