At 02:47 PM 23/06/2005 -0500, you wrote:

><<Thry this:
>
> > update scheduled_work
> >
> > set shift_begin = Cast('07:00:00' AS TIME),
> >
> > shift_end = cast('15:00:00' as time)
> >
> > where shiftcd in (1,4,7,10)
>
>Beauty (that worked a t[h]reat)!

The casting is superfluous, since the engine supports the time literal
directly - as long as you use the 'hh:nn:ss' or 'hh:nn"ss.zzzz'
format. Whatever you do to fudge Windows time strings, remember that the
db engine works on the 24-hour clock.

./heLen