Just get rid of the SELECT:

set @last = case when @d < 1 then 0 else 1 end

>I cant seem to get this right:
>
>set @last = select case when @d < 1 then 0 else 1 end
>-- 0 is sleep 1 is active
>
>I am doing conditional processing in the cursor from hell <g>. I need to create a flag @last and set it 0 or 1 depending on the value of @D. What am I missing?
>
>TIA
>
>__Stephen