Steven-

>Thanks to everyone who replied. I guess I didnt ask the question correctly... I was wanting to know if it is possible to return the result of the query directly with the RETURN rather than storing it to something and then RETURNing that. Also, I wanted to use the SELECT rather than COUNT for the very reason that COUNT moves the pointer!

SQL SELECT statements aren't functions, and don't return values. Thus there's no sense to RETURN SELECT * FROM SomeTable, right? Especially given your example, which selects into an immediate cursor.