Which function in SQL is used to convert all characters to uppercase in SQL?

Programming Language
#1

UPPER() :

This function in SQL Server helps to convert all the letters of the given string to Uppercase. If the given string contains special characters or numeric values, then they will remain unchanged by this function.

Syntax:

UPPER( str )

Parameters:

  • str – The string which will be converted to uppercase

Result: This function will return the uppercase string.

Example:

Using UPPER() function with Lowercase string.

SELECT UPPER('be patient be awake') 
As New;

Output:

New

BE PATIENT BE AWAKE