Difference between revisions of "LOWER()"

From Lianjapedia
Jump to: navigation, search
m
Line 6: Line 6:
  
 
==See Also==
 
==See Also==
[[ISLOWER()]], [[ISUPPER()]], [[PROPER()]], [[SET STRESCAPE]], [[STRTOLOWER()]], [[STRTOUPPER()]], [[STRTRAN()]], [[TRANSFORM()]], [[UPPER()]]
+
[[ISLOWER()]], [[ISUPPER()]], [[LCASE()]], [[PROPER()]], [[SET EXACT]], [[SET STRCOMPARE]], [[SET STRESCAPE]], [[STRTOLOWER()]], [[STRTOUPPER()]], [[STRTRAN()]], [[TRANSFORM()]], [[UPPER()]]
  
 
==Description==
 
==Description==
The LOWER() function converts the characters in the character expression <expC> or memo <memofield> 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 LOWER() function converts the characters in the character expression <expC> or memo <memofield> to lower case.
  
 
==Example==
 
==Example==
Line 15: Line 15:
 
? lower("Lianja")
 
? lower("Lianja")
 
lianja
 
lianja
 
// Another Example
 
use accounts
 
index on lower(company) to company
 
replace company with "Company Name"
 
seek "company name"
 
? found()
 
.T.
 
 
</code>
 
</code>
  

Revision as of 05:54, 22 January 2016

Purpose

Function to convert characters to lower case

Syntax

LOWER(<expC> | <memofield>)

See Also

ISLOWER(), ISUPPER(), LCASE(), PROPER(), SET EXACT, SET STRCOMPARE, SET STRESCAPE, STRTOLOWER(), STRTOUPPER(), STRTRAN(), TRANSFORM(), UPPER()

Description

The LOWER() function converts the characters in the character expression <expC> or memo <memofield> to lower case.

Example

? lower("Lianja")
lianja