>I need to change a field name in an existing table.
>What is the syntax to do this with the Alter Tavle command?
HiJohn
Here is two ways
Alter TABLE mytable ADD COLUMN mybrandnew c(10,0) NOT NULL
Alter TABLE mytable ALTER COLUMN mybrandnew c(10,0)
HTH
Claudio
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20