LOWER in Teradata


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


..