Shift_Begin and Shift_End are Time data types.



update scheduled_work

set shift_begin = '7:00:00 AM',

shift_end = '3:00:00 PM'

where shiftcd in (1,4,7,10)



no worky ("conversion error from string"). What to do to replace the <null>
values with actual times?



Clay Shannon,

Dimension 4 Software





[Non-text portions of this message have been removed]