Query to convert lowercase to uppercase characters in SQL Server

Syntax to convert uppercase characters

If we want to convert characters to uppercase that syntax will be like this

SELECT UPPER(ColumnName) FROM TableName

Ex:

SELECT UPPER(UserName) as UserName, UPPER(FirstName) as FirstName, UPPER(LastName) as LastName FROM UserDetails

OutPut

Syntax to convert Lowercase characters

If we want to convert characters to lowercase that syntax will be like this

SELECT LOWER(ColumnName) FROM TableName

Ex:

SELECT LOWER(UserName) as UserName, LOWER(FirstName) as FirstName, LOWER(LastName) as LastName FROM UserDetails

OutPut