XUPPER

Restriction: This topic applies to Windows environments only.
ANSI DB2 SQL/DS XDB
      X

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)
KERIN
WILSON
CRISP
HOPKINS