Thry this:

In article <20050623192457.33F3922E2E@...>, Clay Shannon wrote:

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

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly