LOWER Function in TERADATA

In Teradata, the LOWER() function is used to convert a string to lowercase. Here's how you can use it with an example:

Suppose you have a table named employees with a column named first_name, and you want to retrieve the first names of all employees in lowercase:

SELECT LOWER(first_name) AS lowercase_first_name

FROM employees;

This query will retrieve the first_name column values from the employees table and convert them to lowercase using the LOWER() function. The result set will contain the lowercase first names, and they will be aliased as lowercase_first_name.