What is the Case function in SQL?

Case facilitates if-then-else type of logic in SQL. It evaluates a list of conditions and returns one of the multiple possible result expressions.

you can use upper ，example

mysql> select name ,author from books;
+------+--------+
| name | author |
+------+--------+
| lkj  | NULL   |
| lkj  | NULL   |
| lkj  | NULL   |
+------+--------+
3 rows in set (0.00 sec)

mysql> select upper(name) from books;
+-------------+
| upper(name) |
+-------------+
| LKJ         |
| LKJ         |
| LKJ         |
+-------------+
3 rows in set (0.00 sec)