Can I Insert a column

[Donna]

I there a SQL statement (query) that can insert a new column in the middle of other columns in a table?
Thanks,
Donna

[MAK]

How does positioning the column make a difference?

This is what I do.

create table mytable (id int,name varchar(100));
alter table mytable add salary money;

The columns will be appended.

When you query it you can do like below.

select id,salary,name from mytable;