>Actually there is a module that checks a database for given records thus this logic. But in one particular database it takes quite a bit of time so I was curious. It has a UPPER() code field and rest is desc and memo field for furhter details.
>
>Regards
>Bhavbhuti
Bhavbhuti,
I would also take the first but as again as Larry said it could count microseconds. A filter OTOH might cause a routine with seek operate slower than a locate. My guess is that it's other code in routine that causes considerable time.
Cetin