>

---

Mark,
>Other than some cleanup benefits cursors are "always" written to disk. IMHO take the easy way and select into table.
>OTOH if you have a DBC open (or create a temp one) you could create-drop a temp view on the fly.
>Cetin

Cetin,
I'm actually not looking for the 'easy way'; I want to know what happens and why it doesn't work.