UPPER Function in TERADATA

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

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

SELECT UPPER(first_name) AS uppercase_first_name

FROM employees;

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