1.

Name the case manipulation functions in SQL?

Answer»

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')



Discussion

No Comment Found