Blog Post

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

Read 642 times
(22 in last 30 days)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating