SQL Server UPPER Function

In this post , I will explain the UPPER function of SQL Server of string functions category.
In my previous posts, I explained STUFF Function, LEN Function, UNICODE Function, LEFT Function, CHARINDEX Function, CHAR Function, ASCII Function, Simple script to backup all SQL Server databases, Table-Valued Parameters and some other articles related to SQL Server.

Here, I am going to explain UPPER function of SQL Server.

UPPER() Function

This function is used to convert the character expression with lower case characters into upper case.
 

Syntax- UPPER(character_expression)
Arguments-

• character_expression : An expression of character data.

Return Type- Returns character data(varchar).

Example-
 

Declare @nstring varchar(50)

set @nstring='Dot Net World'

select UPPER(@nstring)

--OutPut DOT NET WORLD