I have FM 11 Adv.

Is there a function that will filter a text field for a specified word?

For example, I have a text field and want to filter it for the word "Jones".

I want to do this:

IF [FilterInclude(FieldName; "Jones")]

... do some stuff

END IF

It seems that the FM Filter function does filtering to exclude all but the specified values.

I want to 'detect' if the user typed "Jones" into FieldName in any word order. That is, it will

detect the first, second third or nth word occurrence of "Jones".

PatternCount( ) ?

If you mean "Jones" as a word (i.e. not "jonesing" or "cojones"), you will have to check word by word - using either a custom function or a looping script.

PatternCount( ) ?

That did it:

If [patterncount(FieldName; "Jones")>0

worked great... Thank you!