LOWER()

From Lianjapedia
Revision as of 10:49, 13 January 2020 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to convert characters to lower case

Syntax

LOWER(<expC> | <memofield>)

See Also

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

Description

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

From Lianja v5.2 the UPPERC() function can be used to convert utf-8 character expressions to upper case and the LOWERC() function to convert utf-8 character expressions to lower case.

Example

? lower("Lianja")
lianja