At 20:46 26/09/2002 +0200, MySQL wrote: >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:
You need to specify the keyword CONCAT and enclose it in brackets, like this: select CONCAT(number,",",text) from Table Mark -- http://www.good-stuff.co.uk "Life is bigger, it's bigger than you" --------------------------------------------------------------------- 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