XLOWER

Restriction: This topic applies to Windows environments only.

ANSI	DB2	SQL/DS	XDB
			X

Converts a character string to lower case. The parameter x is any expression that evaluates to a character string. The format appears below:

XLOWER(x)

For example:

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