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. Thelower 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"}