Difference between revisions of "STRTOLOWER()"

From Lianjapedia
Jump to: navigation, search
 
Line 14: Line 14:
 
<code lang="recital">
 
<code lang="recital">
 
? strtolower("Lianja")
 
? strtolower("Lianja")
recital
+
lianja
  
 
// Another Example
 
// Another Example
Line 25: Line 25:
 
</code>
 
</code>
  
==Products==
 
Lianja Server, Lianja
 
 
[[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

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.