Query to convert lowercase to uppercase characters in SQL Server

Introduction:

In this article I will explain how to write a query to convert or change lowercase to uppercase or uppercase to lowercase characters in SQL server.

Description:

In previous post I explained how to alter or modify or delete or change already existing column in datatable in SQL Server and many articles relating to SQL Server. Now I will explain how to convert or change lowercase to uppercase or lowercase to uppercase characters in SQL Server. Here I will explain with one example for that I have one table UserDetails like as shown below

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

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email