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 ----- Original Message ----- From: "Jim McAtee" Sent: Thursday, March 18, 2004 4:29 PM Subject: String Concatenation Operator? > Does MySQL have a string contatenation operator, or must you use the > CONCAT() function? > > SELECT firstname + ' ' + lastname AS fullname > FROM customers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
