Ted,
> January   08, 2002   04:01
> 
> why is this 04:01?
> 
> Every time I do this I get the very first date (that no longer
> exists). 
> Why do I get different results. I expect 'select *' is the base and 
> everything else is a varient.
You're going to have to be clearer about the source of your confusion.
I've read your e-mail twice, and I just can't see what the problem is.
The results that you get are exactly according to the documentation.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco