XUPPER

Converts a character string to upper case. The format appears below:

XUPPER(x)

The parameter x is any expression that evaluates into a character string. For example:

SELECT XUPPER(lname)
  FROM employee
  WHERE st = "VA"

xupper(lname)