> > I'm currently using a SELECT * FROM statement, but because I need the
> > columns to appear in particular orders (depending on the scenario), I'm
> > now forced to do a
> > SELECT col1, col2, col3... col200 FROM...
> > or
> > SELECT col2, col3, col5, col7.... col1, col6 etc
> > (depending on the order we need them to appear in the application, or
> > whatever component will display the data).
> > This is very painstaking, especially as there's quite a large
> > combination that we need to cover (about 20-30 SELECT statements in
> > total, with more to come!!!)
> > Is there a way to do something like:
> > SELECT col1, col2, col4, col5, col9, col20, * FROM...
> > but replace the "*" with something else that means "the rest of the
> > columns"? I don't want columns appearing twice in the same result set.
> > I'm thinking of using dynamic SQL to do this, but was wondering if there
> > is any better way around it.