Changing Case

The UPPERCASE, LOWERCASE, and TITLECASE directives change the case of column values they are applied to.


lowercase <column>
uppercase <column>
titlecase <column>

The directive performs an in-place change of case.


Using this record as an example:

  "id": 1,
  "gender": "male",
  "fname": "Root",
  "lname": "JOLTIE",
  "address": "67 MARS AVE, MARSCIty, Marsville, Mars"

Applying these directives

uppercase gender
titlecase fname
titlecase lname
lowercase address

would result in this record:

  "id": 1,
  "gender": "MALE",
  "fname": "Root",
  "lname": "Joltie",
  "address": "67 mars ave, marscity, marsville, mars"