CODE

Returns the ASCII character code for the first character of the string supplied.

CODE ( <field_name or character> )
  • field name or character: The field or character for which to return the ASCII code.

Example: create a field on the CUSTOMER table that returns the ASCII code for the first character of the surname field.

CODE( CUSTOMER.SURNAME)