field doesn't contain

[rrmcguire]

Hello,

Is there a way to write a formula to add into the select expert to not include records where a field does not contain a certain word?

i.e. the field is DATCOMMENT, and I don't want to include records which include the word 'partial'

thanks

 

[swiss2007]

try using the following formula in the select ----> selection formulas ----> Record

Not({DATACOMMENT} LIKE '*partial*')

 

[rrmcguire]

this worked...thanks