Returns characters from the beginning of a string.

Syntax:

number #LEFT string

Examples:

6 #LEFT 'Smith,John' equals 'Smith'

If the field FULLNAME equals ‘Smith,John’

then ((',' #FIND FULLNAME)-1) #LEFT FULLNAME equals 'Smith'