At 09:56 PM 3/11/2003 -0500, you wrote:

>Hello all,
>
>Is there a way to insert the current time into a timestamp field is is
>null? For instance,
>
>SELECT Time1, Time2 FROM MyTabe;
>
>If either the values is null, I would like to have the curren time
>filled in...

What database and version?

And do you mean you want to *store* current time automatically if null, or
you want to *output* current time if null is stored?

heLen