Cool... thanks for the info, Mark.

Tommy

>If you go with SPT, you can always use the TO_DATE() Oracle function.
>
>TO_DATE('20021231', 'YYYYMMDD')
>
>which makes you independent of the time portion. The time portion will be implicitly midnight.