Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 3.0 for Visual Studio 2013 > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > Functions Overview > String Functions > XLOWER

XLOWER

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"
xlower(lname)
kerin
wilson
crisp
hopkins
Parent topic: String Functions
Previous Topic Next topic Print topic