| Different case manipulation functions in SQL?
Below are the 3 case manipulation functions in SQL
(1)LOWER :- This function is used convert string in lowercase and syntax is given below
LOWER('cRACKYOURINTERVIEW')
Output is:- crackyourinterview
(2)UPPER :-This function is used to convert string in upparcase and syntax is given below
UPPER('crackyourinterview')
Output is:- CRACKYOURINTERVIEW
(3)INITCAP:- This function will return string in proper case and convert first letter in uppercase and rest in lower
INITCAP('CRAckyourinterview')
Output is:- Crackyourinterview | | |