Then, I would not only stay away from SELECT *, but I would try to change all the SELECT * from that table in the existing code to specify the old field list before adding the new fields. That way, I will be sure that I won't break the other parts of the application.

Specifying the fields you need in the SELECT-SQL is more typing, but you have total control on the resulting cursor/table structure.

>I should add that of the reasons for doing this is that some fields will probably be added and I don't want to have to track down what I forgot. This SQL feeds a sales order screen that I am still working on. The added fields will not be related to anything else.