<<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)!

I think I ran into that roadblock before, but the old pink mass just ain't
what it used to be (IOW, I forgot the solution).

Clay Shannon,
Dimension 4 Software