LOWER() function in SQL Server

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

 Syntax:-

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

For example,

SELECT LOWER(‘Vivek Johari’)

Result:-

vivek johari

DMCA.com

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