>Thanks but, if you read carefully my question, I always first SELECT the table I'll work with. Besides, this doesn't explain why I get full results in one table and only partial results in another.
>Ulises.
If LOCATE doesn't work as expected, and you're CERTAIN the data should be FOUND(), you may have a corrupted index. By default LOCATE uses Rushmore optimization and will use an available index key if one matches your search.
Try LOCATE ... NOOPTIMIZE. If that works properly, rebuild your indices (do NOT simply REINDEX).
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up