Hi Frank, You can use the concat() function:
select concat(numer, ',', text) from Table. The online docs for MySQL contain a great reference for functions: http://www.mysql.com/doc/en/Functions.html --jeff > 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 --------------------------------------------------------------------- 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