UCase Syntax:
SELECT UCASE(column_name)
FROM table_name
Students table:
| ID | NAME | State |
|---|---|---|
| 1 | Tom | Arizona |
| 2 | Linda | Texas |
| 3 | Helen | Florida |
| 4 | Robert | California |
UCase Example:
SELECT name, UCASE(name)
FROM students;
UCase Result:
| Name | UCASE(name) |
|---|---|
| Tom | TOM |
| Linda | LINDA |
| Helen | HELEN |
| Robert | ROBERT |