Name the case manipulation functions in SQL?
There are 3 types of case manipulation functions in SQL.
(1)UPPER:-This will convert string in uppercase, And syntax is given below.
UPPER('crackyourinterview.com')
(2)Lower:-This will convert string in lowercase, And syntax is given below.
LOWER('CRACKYOURINTERVIEW.COM')
(3)INITCAP:-This will convert first letter in uppercase and rest in lowercase.
INITCAP('crackyourinterview.com') | |