Returns the position of a string within another string.

Syntax:

string1 #FIND string2

Examples:

',' #FIND 'Smith,John' equals 6

If the field FULLNAME equals ‘Smith,John’

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