you can use the concat function:
http://www.mysql.com/doc/en/String_functions.html
SELECT concat(vend_city,', ',vend_state,' ',vend_zip)
FROM Vendors
ORDER BY vend_name;
> -Original Message-
> From: Gilbert Wilson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 10, 2003 2:42 PM
>
> SELECT vend_city+', '+vend_state+' '+vend_zip
> FROM Vendors
> ORDER BY vend_name;
SELECT
CONCAT( vend_city, ', ', vend_state, ' ', vend_zip )
FROM
Vendors
ORDER BY
vend_name
> The solution is to concatenate the three columns. In SQL SELECT
> statements, you can concatenate columns usi
