UPPER

UPPER returns the value in a given string converted to upper case.

UPPER( <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 upper case.

UPPER([Household.State])

  • Returns COLORADO for an input of colorado
  • Returns COLORADO for an input of colorado
  • Returns NEW JERSEY for an input of new jersey