Hi group, Someone asked a question about how he could change a column name and have his old application continue using the same table while he is updating the client. This means: He has a table with columns: ColA, ColB and he is forced to change the columns names into ColX, ColB and possibly the table name. So, he was asking how he could do that change and continue using his application that still uses the old table and columns.
I think I have found a solution: using MERGE tables. It that user is still in need of this I will be happy to send it over. Unfortunaly, I am unable to find his post as I have a lot of mails to search in!!! Thanks, __________________________________ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/