Important Points About SQL UPPER() Function

  • UPPER() function in SQL allows us to convert the string text into uppercase.
  • It takes only one parameter and converts the entire string into upper case.
  • It is similar to the UCASE() function.
  • Special Characters like “@”, “%”, “+” etc. and numerical characters remain unchanged, only the lowercase alphabetical letters get transformed into uppercase.

SQL UPPER() Function

The SQL UPPER() function is a string function that converts all the strings in the table to uppercase.

Similar Reads

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....

Syntax

SQL UPPER function syntax is:...

SQL UPPER() Function Examples

Let’s look at the examples of UPPER() function in SQL. Check the SQL UPPER function with examples to understand it better....

Important Points About SQL UPPER() Function

UPPER() function in SQL allows us to convert the string text into uppercase. It takes only one parameter and converts the entire string into upper case. It is similar to the UCASE() function. Special Characters like “@”, “%”, “+” etc. and numerical characters remain unchanged, only the lowercase alphabetical letters get transformed into uppercase....

Contact Us