CONCAT() function
I am using the following SQL statement using MySQL v4.1:
SELECT CONCAT(vend_name, ' (', 'vend_country', ')')
FROM Vendors
ORDER BY vend_name
The results come back ok for the 'vend_name' column but the 'vend_country' column is returned as (vend_country) - So it is displaying the parenthesis and the name of the column, not the results in the column. Any ideas?
Subject
Written By
Posted
CONCAT() function
April 11, 2005 06:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.