UPPER() Function in SQL
The UPPER function in SQL is an in-built function that changes lowercase characters or strings to capital cases. Certain characters like integers (0-9) or special characters like (“@”, “-” “/”, “&” etc.) remain unchanged in the result.
It is used to display the output in CAPITAL CASE and is supported by all major SQL-based DBMSs.
Note: UPPER and UCASE functions perform the same operation on strings. In older versions of SQL, some databases (like Db2 DBMS)used the UCASE function, while others used the UPPER function. Now both the functions are supported by all major databases.
The UPPER function is supported in SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse, MySQL 4.0, Oracle, DB2, and all other major Database systems.
SQL UPPER() Function
The SQL UPPER() function is a string function that converts all the strings in the table to uppercase.