Thanks Hugo for the explanation. I learn so much from this forum. It does seem to be a pretty odd way to handle time. Does this change in SQL 2008 with separate date and time data types?

Thanks again.