Michelle, sorry for that "help credit" goes to Steve :) I did tried that INTO CURSOR mycur before I even asked this question and didn't work. According to MS book, I placed the INTO CURSOR after the JOIN section and also tried at the bottom too. Whatever, it is all working now, whew. Thanks to everyone that helped. Nonetheless, the NOCONSOLE should still work without anything else, right (again, according to MS book, it's a "stand alone" argument)?

Chuck

>You need to select into a cursor...at the end of the SELECT statement you can add:
>
>into cursor mycursor
>
>There is no need for 'to screen', or 'noconsole' when you do this