Use of LOWER Function in SQL

Use of LOWER Function in SQL:

(1) “LOWER” function is used for converting text in lower case.

(2) Let’s take an example to convert the text of Vendor Name into the Lower case as shown.

(3) Select the database in the SQL server and click on the “New Query” button as shown.

Select the database in the SQL server and click on the new query button

(4) After that new query editor opens as shown.

new query editor open in sql

(5) After doing the above steps, write a query in the editor, as shown.

Lower function query in sql
–//LOWER Function
Select [No_] AS [Vendor No.],[Name] AS [Vendor Name],
LOWER([Name])AS [Lower(Text into Lower case)]
Fromdbo.[CRONUS India Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] 
–//LOWER Function

(6) Then Execute or Press F5 to run the query and see the result as shown.

execute sql lower function query

Use of UPPER Function in SQL
SQL SELECT DISTINCT Statement
How to Take BACKUP from SQL Database
LOWER (Transact-SQL)– Microsoft Docs
How to convert SQL Query into JSON Format in SQL Server

Leave a Reply