> or must you use the CONCAT() function? Yes
SELECT concat(firstname,' ',lastname) AS fullname FROM customers; Cheers, Andrew -----Original Message----- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Thursday 18 March 2004 22:30 To: [EMAIL PROTECTED] 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]