>>When I need to index DATE field I always index it with DTOS().
>
>Hmmm, never did this before. Do you use it in VFP or in other back-ends?
Only in VFP, in other backends you didn't have such possibility :-)
I rarely need to have index by date only and when we speak about compound index key DTOS() is the function :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.