Hi.

I want to write a stored procedure that returns its results as a csv-
style string value:

create procedure returns1()
returns
(s varchar(40))
as
begin
select a + ';' b + ';' c
from tableA
into :s
end

or

create procedure returns1()
returns
(s varchar(40))
as
begin
select a,b,c
from tableA
into :a, :b, :c

s=:a+';'+b+';'+'c';
end

do not work (the first example actually works in paradox with bde)



Any clues?