Hi all, I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle world. Like this. select numer ||','|| text from Table: Where the output will be eg. 1,HI 2,Frank And so on.... Hope one of you can see my problem. I've tried the same on mysql, but it mess all up. Regards Frank --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php