> 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 using a special operator. > Depending on what DBMS you are using, this can be a plus sign (+) or two > pipes (||). The pipes are the concatenation operator in PGSQL, I know. What others they are used in I do not know. I'm not sure what DBMS uses the plus sign. But then, I'm only familair with mySQL and PGSQL. Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
