CHAR columns can be concatenated by using the operator '&'.
SELECT name, city&', '&state&' '&chr(zip) address
FROM customer
The numeric column 'zip' must be converted first, before the statement can be executed.
