SQL Server : Upper Case and Lower Case of A String.

This time we will discuss how to change letters to capital or lowercase letters. There are two functions used, the UPPER() function to convert string text to uppercase, and the LOWER() function to convert string text to lowercase.

Syntax:

UPPER(text) --> to uppercase

LOWER(text) --> to lowercase

e.g.:

DECLARE @String VARCHAR(50) = 'Learn to be happy right now!'

SELECT UPPER(@String) [Up], LOWER(@String) [Low]