The UPPER function is the SQL Server function that converts character expressions to upper case. It works when either an ad hoc string is passed to the function or a column name is passed.

Now, let us explore the scope and work of this function more thoroughly.

Prepare the Table

To start our examination, let’s prepare a very small table with four columns. The first column is the ID column. All other columns are character columns – char, varchar, and nvarchar respectively.

#sql server #sql functions #sql upper #sql