as there is no 'next' or 'break' instruction should I be able to do this
within a dbproc instead to terminate the loop?

FOR SELECT ..
WHERE .. :wk_hours > 0
DO
BEGIN
...
wk_hours = -1;
end

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx