In an application using R:Base 7.1, I have three columns named: ADD_
CONT_ STD_ R:Base permitted me to create these columns when I built the database. The user would now like me to rename these fields as follows: ADD_ to ADDL CONT_ to CONTI STD_ to STDP These commands fail when I try to rename the columns: ALTER TABLE PAYROLL ALTER COLUMN ADD_ to ADDL CURRENCY ALTER TABLE PAYROLL ALTER COLUMN CONT_ to CONTI CURRENCY ALTER TABLE PAYROLL ALTER COLUMN STD_ to STDP CURRENCY R:Base the error messages: COLUMN ADD_ not found COLUMN CONT_ not found COLUMN STD_ not found I thought it might a problem with the SINGLE wild card character, so I typed: SET SINGLE='?' I continue to get the same messages, yet: LIST COLUMN ADD_ LIST COLUM CONT_ LIST COLUMN STD_ all show the correct columns. Any ideas of how to get around this to rename the columns? David Blocker David Blocker [EMAIL PROTECTED] Telephone: 781-344-1920 Cell Phone: 339-206-0261
