At 09:52 AM 5/03/2004 +0200, you wrote:

>How do I change the datatype of an field in a table. Table previously got
>added the wrong datatyp.
>
>ALTER TABLE MineTable
>ADD CityGMT INTEGER NOT NULL';
>
>Now I want CityGMT to become an float so i tried :
>
>ALTER TABLE CItyGMT
>ALTER CityGMT FLOAT NOT NULL;

If the conversion were possible, the syntax would be
ALTER TABLE CityGMT
ALTER CityGMT TYPE FLOAT;

But integer - to - float is not a valid conversion.

/hb