Skip to main content

String functions

For string processing, CAQL offers the following functions:

LOWER()​

LOWER(value) → lowerCaseString

Convert upper-case letters in value to their lower-case counterparts. All other characters are returned unchanged.

  • value (string): a string
  • returns lowerCaseString (string): value with upper-case characters converted to lower-case characters

Examples

LOWER("AVOcado") // "avocado"

UPPER()​

UPPER(value) → upperCaseString

Convert lower-case letters in value to their upper-case counterparts. All other characters are returned unchanged.

  • value (string): a string
  • returns upperCaseString (string): value with lower-case characters converted to upper-case characters

Examples

UPPER("AVOcado") // "AVOCADO"