It will convert the string characters into lower case.

Input: string
Output: Lower case representation of the given string

Syntax:

SELECT LOWER(string)

Example:

SELECT LOWER('TERADATA')

Result: teradata

Note:
The function will convert all the letters to LOWER case irrespective of input string’s case.
The function is not applicable for numbers. It will throw bad argument type error.
If numbers are enclosed with quotes to represent as strings, it will be unaffected.
TRIM function will not be undertaken here.

Few ForgetCode Examples:

SELECT LOWER('Teradata')

Result: teradata

SELECT LOWER('TEraDAta')

Result: teradata

SELECT LOWER('TERADATA123')

Result: teradata123

..