UNICODE

UNICODE returns the Unicode character code for a supplied character.

UNICODE( <field_name or character>)

  • field name or character: A field containing a character value or a character value.

Example: create a virtual field on the Individual table to show the character code for each value in the Home Ownership field.

UNICODE( [Individual.Home Ownership] )

Results:

  • Returns 79 for an input of O
  • Returns 67 for an input of C
  • Returns 82 for an input of R
  • Returns 80 for an input of P
  • Returns 85 for an input of U