Try: 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
Note the use of the IDQUOTE character (the backwards apostrophe, located, on my keyboard, to the left of the number 1 key, as the lower case version of the tilde character). First, do SHOW CHAR to make sure that IDQUOTES is set properly. -- Larry
