SQL UCASE

UCASE function is to convert to uppercase the value of a column.

SQL syntax UCASE

SELECT UCASE (column) FROM table

Example SQL UCASE:

Given the following table 'orders'

idorderclientprice
1p1Harry100
2p2Clark300
3p3Smith250

SELECT UCASE (client) FROM orders

The result will be:

client
HARRY
CLARK
SMITH