Is there an SQL query that will change the column data type? Eg - I want to change a column from having integers to decimal values.
There isn't in ANSI SQL but most vendors have added different extensions to cater for this.
look up "alter table" and "alter column"; should give you a good starting point (applies to sql server, mysql and oracle (i think))
Sorry, should've thought to mention it. I use MS Access. I looked at ALTER TABLE but it seems to be more for adding new columns rather then editing existing ones.