CHR

Converts the value supplied into the equivalent ASCII character for that number.

CHR ( <field_name or number> )
  • table name or expression: An integer field or an integer value.

Example: Create a field on the CUSTOMER table that surrounds the customers' surname with double quotes.

CHR(34) + [CUSTOMER.SURNAME] + CHR(34)