Charles Tassell writes:
> Might want to try date BETWEEN '01/4/2000' AND '01/5/2000' as well, this
> is probably optimized better (although I may be wrong.)
It isn't. It's immediately converted to the below, so it's actually a few
cycles slower to use it.
> >How about you write your queries like:
> >
> >date >= '01/4/2000' and date < '01/5/2000'
--
Peter Eisentraut Sernanders väg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden