Per-Erik, Thanks very much for getting back to us. I'll have to try out some stuff later but it's good to know inserts/updates should work.
I mentioned on another thread that I thought the returning of results sets via a select statement in procedures was possibly a useful side effect rather than by design.
To answer your question Tomi, it depends on what your trying to do. When your using functions in SQL it doesn't really make much sense to return results sets, by their very nature they should be returning single values and not sets.
The reason it's not a problem is that you should be able to return table data simply by using joins etc in the actual select statement rather than doing it via a function.
Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog
http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information