Hi Andrew,

>You have no guarentee what order the fields will be in, so group by 1 or >order by 1 are certain to give you problems in the future. If you add a field to the table then all of your select * views will bomb.

Yes, I abandoned this idea already - so thanks for the info.

I just getting "initiated" with writing these statements myself, and they are biting me a little.

Mel Cummings