LOWER

Lower returns the value in a given string with the first character of each word converted to upper case.

LOWER( <field_name or string>)

  • field name or string: Field or string to be used

Example: create a field at the Household level to convert the State field to lower case.

LOWER([Household.State])

Results:

  • Returns colorado for an input of Colorado
  • Returns colorado for an input of COLORADO
  • Returns new jersey for an input of New Jersey