> >CURRENT_TIMESTAMP worked great, THANKS! LEE
>
> Remember that there is a semantic difference between
> 'NOW' and CURRENT_TIMESTAMP. 'NOW' produces the time
> that the action is taken, so different instances of
> 'NOW' in a single transaction will produce different
> values. CURRENT_TIMESTAMP is constant for the duration
> of a transaction.
>
> Regards,
>
>
> Ann
>

OOh you've got my ears up - I understood some tome ago that NOW was going to
be deprecated. If NOW is not constant within a transaction and
CURRENT_TIMESTAMP is, then I would urge he powers to re-consier loosing NOW.
It would be a very handy inclusion. Some transactions are longer than I
would like them to be, and I don;t want the same stamp across records in
this fashion.
Alan