LEFT

Returns the number of characters specified from the left hand end of a string.

LEFT( <field_name or string> , LENGTH ))

  • Field name or string: The field or string to use

  • LENGTH: The number of characters to select.

Example: create a field at the CUSTOMER level that shows the first 5 figures from their surname.

LEFT( [CUSTOMER.SURNAME], 5 )