Change Case directive

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

results in this record:


Created in 2020 by Google Inc.