LOWER() function in SQL Server

LOWER():- This function is used to convert the value of a column to lower case


 Select LOWER (string)
 SELECT LOWER(column_name) FROM table_name

For example,

SELECT LOWER(‘Vivek Johari’)


vivek johari


About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.
This entry was posted in SQL Functions, SQL Server and tagged . Bookmark the permalink.

Leave a Reply