Offtopic help

[Jorge Bastos]

Hi people,

I wounder if anyone can give me a hand.

I want to create a view or function/procedure that returns a string, and
inside that function I have to pass two arguments, and do a SQL statement
like this:

 

Select * from tbl where field1=art1 and field2=arg2;

Result=concat(field3 ,';')         <= for each record found I need to
concatenate the result, and return it on the end.

 

How can this be possible?