JOIN NOW

Informatics Practices

What will be the output of following code ?

mysql> SELECT LCASE('INFORMATICS PRACTICES CLASS 11TH');

SQL Queries

1 Like

Answer

+-------------------------------------------+
| LCASE('INFORMATICS PRACTICES CLASS 11TH') |
+-------------------------------------------+
| informatics practices class 11th          |
+-------------------------------------------+

Working

The LCASE() function in SQL is used to convert all characters of a given string to lowercase. In the query, LCASE('INFORMATICS PRACTICES CLASS 11TH') converts the entire string to 'informatics practices class 11th'. Therefore, the output is 'informatics practices class 11th'.

Answered By

1 Like

Related Questions