Hi Wayne,

> In Interbase \ Firebird is it possible to write a Stored Proc that can

return

> a result set - like in SQL Server or can Interbase \ Firebird only return

Output

> parameters and return codes?

Yes, selectable stored procs are supported in IB/FB.
Look at LangRef guide Chap 3 "Procedures and Triggers". Especially the
"Suspend" keyword which permits what you want to do.

> The utility that i am using to manipulate the Database only allows me to
> return output params and return error codes - That is why i am asking.

This shouldn't depend on your tool. A selectable SP will be called just like
a select :

Select * from <your_selectable_SP>


Regards.

--
Jerome