May 16, 2021 SQL
The SQL upper() function letter case conversion function, which turns letters into capitals - returns the string str and changes all characters mapped to uppercase based on the current character set.
Returns the string str, which changes to capitals based on all characters mapped from the current character set.
SQL> SELECT UPPER('Allah-hus-w3cschool');
+---------------------------------------------------------+
| UPPER('Allah-hus-w3cschool') |
+---------------------------------------------------------+
| ALLAH-HUS-W3CSCHOOL |
+---------------------------------------------------------+
1 row in set (0.00 sec)You can also refer to the UCASE() function, which converts the value of a field to capital.