LOWER

Description

Converts the characters in a string_expression to lower case.

Syntax

LOWER(string_expression)

Examples

LOWER('JohnSmith@GOTMAIL.COM') returns 'johnsmith@gotmail.com'

Return value datatype

String

Impact of null value

If input is null, returns null.