I'm not concerned about the stars. Give them to whomever you think helped you.

As to the noconsole, I never used it in SQL, so I don't really know why it's not working for you.

Michelle

>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
>