Re: How to delete column

Error in my post. The parenthesis in the following line should not be there

> CREATE TABLE TEMP AS SELECT COL1,COL2,COL3,COL4 FROM ORIG);

                                            Remove this ---^

ALso, it's probably a good idea to back up the table first :-)

-- 
James "I'd rather fall off Ilustrada than ride any other horse" Petts