Difference between revisions of "STRTOLOWER()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{YLM to do}}
 
 
==Class==
 
 
 
 
 
==Purpose==
 
==Purpose==
 
+
Function to convert characters to lower case
  
  
 
==Syntax==
 
==Syntax==
 
+
STRTOLOWER(<expC>)
  
  
 
==See Also==
 
==See Also==
 
+
[[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.
  
  
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
 +
? strtolower("Recital")
 +
recital
  
 +
// Another Example
 +
use accounts
 +
index on strtolower(company) to company
 +
replace company with "Company Name"
 +
seek "company name"
 +
? found()
 +
.T.
 
</code>
 
</code>
  
==Products==
 
  
 +
==Products==
 +
Recital Server, Recital
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:String Data]]
 +
[[Category:String Data Functions]]

Latest revision as of 14:25, 21 July 2010

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("Recital")
recital
 
// Another Example
use accounts
index on strtolower(company) to company
replace company with "Company Name"
seek "company name"
? found()
.T.


Products

Recital Server, Recital