SELECT CONCAT(title, ' is in ', book) FROM MyTable

--

Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com/mysql

<a href="http://www.itjobfeed.com/mysql"> mysql it jobs</a>



"Peter Ludwig" <green@abwesend.de> wrote in message
news:f1ujkf$bt8$1@online.de...
> Hi,
>
> I have created a stored procedure in which I want to create a table.
> The procedure has some parameters, one of them I want to use for the table
> name.
> The table name should be dynamically put together like
> `parameter + static name`
>
> How can I do that?
>
>
> Yours sincerely
>
> Peter
>
>
>