|
Subject:
|
Query Problem with a field string
|
|
Posted By:
|
Brian263
|
Post Date:
|
11/18/2004 4:43:50 PM
|
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.
|
|
Reply By:
|
Clive Astley
|
Reply Date:
|
11/19/2004 3:11:11 AM
|
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
|
|
Reply By:
|
Brian263
|
Reply Date:
|
11/19/2004 4:12:38 PM
|
That worked perfectly.
Thank you Clive
|
|
