SQL LCASE

The LCASE function is to convert to lowercase the value of a column.

SQL syntax LCASE

SELECT LCASE (column) FROM table

Example SQL LCASE:

Given the following table 'orders'

idpedidoclienteprecio
1p1HARRY100
2p2CLARK300
3p3SMITH250
SELECT LCASE (client) FROM orders

The result will be:

cliente
harry
clark
smith