Try these..

>I've figured out how to add and delete columns, but not how to alter them. I know there's an "alter column", but the syntax doesn't give a place to put what you're altering it to.
>
>I want to do two things:
>
>1. Change the type of a field
ALTER TABLE [tablename] ALTER COLUMN [columnname] [newtype]

>2. Change the name of a field
ALTER TABLE [tablename] RENAME COLUMN [oldcolumnname] TO [oldcolumnname]

>
>I'd like to do both of these without changing the values in the fields. Obviously, I can't go changing a float to an integer without hurting anything, but I'd like to be able to change a numeric 9.2 to a currency.
>
>Thanks,
>
>-Michelle


Geno Prida