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.

CONCAT(CHR(34),[CUSTOMER.SURNAME],CHR(34))