Case conversion functions: UPPER, LOWER

These functions return a string formed by converting the characters in the argument to uppercase or lowercase respectively, provided the character is alphabetic:

Varchar UPPER( value Varchar )

Varchar LOWER( value Varchar )

Examples

The following code:

SELECT CUSTOMERS.CUSTID, CUSTOMERS.CUSTOMNAME, UPPER(CUSTOMERS.CUSTOMNAME)

FROM "../Data Sources/MyDatabase/CUSTOMERS.SMA" CUSTOMERS

returns:

101,Signal Engineering,SIGNAL ENGINEERING

109,InfoEngineering,INFOENGINEERING

111,Advanced Design Inc.,ADVANCED DESIGN INC.

…

The following code:

SELECT CUSTOMERS.CUSTID, CUSTOMERS.CUSTOMNAME, LOWER(CUSTOMERS.CUSTOMNAME)

FROM "../Data Sources/MyDatabase/CUSTOMERS.SMA" CUSTOMERS

returns:

101,Signal Engineering,signal engineering

109,InfoEngineering,infoengineering

111,Advanced Design Inc.,advanced design inc.

…

Copyright Actuate Corporation 2012