contained within text

[pmusaev]

what function would i use to test if a given text string appears in a text field.

ie. say i have a field that holds the value "THIS STRING IS TO BE TESTED" and I have a function that calls... If FIELDNAME CONTAINTS "STRING" RETURN POSITIVE. any help would be appreciated.

cheers!

[-Queue-]

If [PatternCount( " " & field " ", " stringtotest " )]

or

If [Position( " " & field & " ", " stringtotest ", 0, 1 )]

The extra spaces are to ensure that a partial match isn't found, such as looking for 'ask' in a field containing 'task'.

[pmusaev]

sanks Queue!