Hi Jim,
Unfortunately you do have to use the CONCAT() function to make sure it works on all MySQL installations. The operator used in other DBs, and which can be used in MySQL when running in ANSI mode, is ||, not +:
SELECT firstname || ' ' || lastname AS fullname FROM customers
But if MySQL isn't in ANSI mode (specifically, the PIPES_AS_CONCAT part), which is typical since it's not enabled by default, || is logical OR. :-(
Matt
You can also use simple proximity as a concatenation "operator":
mysql> select 'hello,' ' world'; +--------------+ | hello, | +--------------+ | hello, world | +--------------+
This does not depend on the server SQL mode.
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
