SUBSTRING
This function will return a number of characters from the middle of a string.
SUBSTRING( <field_name or string> , START , LENGTH )
- field name or string: The field or string to obtain the substring from.
- START: The character position to start obtaining the substring from.
- LENGTH: The number of characters to obtain from the string.
Example: create a field on the CUSTOMER table that retrieves 3 characters from the SURNAME field beginning at the second character.
SUBSTRING(CUSTOMER.SURNAME,2,3)