SQL lcase()
lCASE() function converts the value of a field to lowercase.SYNTAX :
LCASE(column_name)
id | name | age | city | bill |
| 1 | Tom | 34 | Paris | 5300 |
| 2 | Jhony | 51 | London | 400 |
| 3 | Ram | 64 | Delhi | 20000.7 |
| 4 | Simon | 23 | Portland | 32.65 |
LCASE(column_name)
id | name | age | city | bill |
| 1 | Tom | 34 | Paris | 5300 |
| 2 | Jhony | 51 | London | 400 |
| 3 | Ram | 64 | Delhi | 20000.7 |
| 4 | Simon | 23 | Portland | 32.65 |