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
At 16:45 -0600 3/20/04, Matt W wrote:
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
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?