Hi Guys !

Could U all give me a hand with this problem of mine. I have 500.000 records in database... such as..

>> Customer.Dbf <<
>> Records <<

@ Customer.Name @ (Ficticious)

Jacky Chan
Jet Lee
Andy Lau
Bruce Willis
Demi Moore
Julia Roberts
...

If i want to search customer with the words "chan" and using Command :

>> LOCATE FOR "chan" $ Customer.Name
It did find a match...
But with 500.000 records that i have, it could take a fortune of time
about 3-4 seconds

>> SQL
It did find a match...
But with 500.000 records that i have, it could take a fortune of time
about 2-3 seconds

>> SEEK "Jacky" or someelse
It did find a match and the best match only took less than a second, but the input must be the first words
in the customer.name... That's Jacky...