>But if I put use the cursor I have to define the fields. I discovered that if I use straight-forward SQL statements it suits the purpose I need, I'm using it in 1 procedure where I destroy the temporary table as soon as it's done. It took some experimentation but I found it answered a few questions
>Thanks for the advice
>Perry

Hi Perry, Gald that you've got it working OK, but really INTO CURSOR... should be the same as INTO TABLE...
Regards