Hey Jorge - SQL uses a + as a concatenation function so
Select field3 + ';' field4 from tbl where field1=art1 and field2=arg2;
You will have to work through the details - just watch your comma placement
since it is easy to screw up and test in the UI first, not code so you can
Technology Catalyst, LLC
From: Jorge Bastos [mailto:mysql.jorge@stripped]
Sent: Saturday, June 28, 2008 8:58 AM
Subject: Offtopic help
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
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?