Alter field type

[Beginner]

I have to change the field type of a column/field iin an
existing table from Number(long Integer) to Percent.
How do I do it with the SQL Statement ?

ALTER TABLE ZBILLINGNEW ALTER COLUMN [D Split %] Number
(Percent);

How do I change the above statement so it works?
Please help

Beginner

 

[John Vinson]

I have to change the field type of a column/field iin an
existing table from Number(long Integer) to Percent.

ummm... there IS no Percent datatype. Percent is a Format property
which can be applied to a Number field.