multiple where condition

[nickmarlborough]

hi, 

would like to do a:

load*

resident [table] where [FIELD 1 contains 'Yes'] and where [FIELD 2 contains 'team']

how would i do this in the load editor?

[Brian_C]

Try

load*

resident [table]

where [FIELD 1]= 'Yes'  and [FIELD 2]= 'team';

[Or]

Wildmatch() is your friend!

e.g. Wildmatch(Field1,'*Yes*')