>Thanks for the swift reply.
>
>The data in rawhits.hostaddy contains the "%" where needed.
>
>Sample:
>
>%.crawl.yahoo.net
>crawl%.googlebot.com
>crawl%.cuil.com
I'm not 100% sure that embedded % will work. BTW, I tested in SQL Server and you can use LIKE in SQL Server correlated subquery but apparently not in VFP.
In VFP try to use INNER JOIN for now instead of EXISTS.
If it's not broken, fix it until it is.
My Blog