LOWER() function in SQL Server

By | August 14, 2014
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

Leave a Reply