Previous Next JavaScript must be enabled to correctly display this content

## upper and lower functions

The `upper` and `lower` are simple functions to convert to fully upper case or lower case respectively. The `upper` function converts all the characters in a string to uppercase. The`lower` function converts all the characters in a string to lowercase.

    returnvalue upper (source)
    returnvalue lower (source)

    source ::= any*
    returnvalue ::= string

Example 1: Fetch the full name of the passenger in uppercase whose ticket number is 1762376407826.

    SELECT upper(fullname) AS FULLNAME_CAPITALS
    FROM BaggageInfo
    WHERE ticketNo=1762376407826

Output:

    {"FULLNAME_CAPITALS":"DIERDRE AMADOR"}

Example 2: Fetch the full name of the passenger in lowercase whose ticket number is 1762376407826.

    SELECT lower(fullname) AS fullname_lowercase
    FROM BaggageInfo WHERE ticketNo=1762376407826

Output:

    {"fullname_lowercase":"dierdre amador"}