SqlExpression LOWER

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Input 4 Output 5 Example

Syntax

LOWER( source_string )

Purpose

Converts a string to all lower case characters

Input

• source_string [VARCHAR] - string to convert to lowercase

Output

• [VARCHAR] - source_string with all characters converted to lowercase. Returns null if source_string is null and empty string for empty string

Example

Function	Result
LOWER('abdsrIRISfsdfs2134*&')	abdsririsfsdfs2134*&
LOWER( )

---

Return to Built in Function details