Looked at the sql statement for real:
if you are querying vfp data also try the between() function - help shows this function to be optimizable. Try out 2 statements with GreaterTHan and LEssthan as well. You checked your indices ? Showplan also helps <bg>.

regards

thomas