> Where do I find information explaining the how to.

In the Interbase-Manuals

> second. I need a SP that returns a recordset

create procedure P_TEST returns (ID smallint, TABLENAME char(31)) as
begin
for select r.RDB$RELATION_ID, r.RDB$RELATION_NAME from RDB$RELATIONS r
into :ID, :TABLENAME do suspend;
end

> Third I need it be callable from ASP using ODBC.

select * from P_TEST


--
Thomas.Beckmann@...
Martens & Prahl EDV, Wielandstr. 14c, 23558 Lübeck
Telefon 0451-39904-525 • Telefax -559