Thanks for your interest.

I have about 12000 records where I need to search a field for the word StFund. How do I go about setting up the criteria to find all the incidences where the word Stfund occur. Below is a sample of 5 records of data that this field has in it. I highlighted the word to show how burried it can be.

1 StFund
2 VillanovaInsCoA8plpd,wc,GoldenstFundEagleauto,LegionInsA
3 StarnetInsA8plpd,auto,AmGuarantee&LiabA8excess,StfundB++13wc
4 StarnetInsA8plpd,auto,AmGuarantee&LiabA8excess,stfundB++13wc
5 St.FundVirginiaSuretyA-9plpd,auto,wc,AmGuaranteeA+14ex

Thanks for your help.

SELECT Table1.MyField, InStr([MyField],"StFund") AS Expr1
FROM Table1
WHERE (((InStr([MyField],"StFund"))>0));

You will have to adjust the criteria for your oddities like St.Fund (cf StFund). Hope this helps.

Best wishes,

Clive Astley

That worked perfectly.

Thank you Clive