try this: select customername || custid as NEW_CUST_NAME from customer;
Attachments
Library
Quick Reference
Archives
Sample Index
2004 Indexes