Alter field type

  • Thread starter Thread starter Beginner
  • Start date Start date
B

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
 
I have to change the field type of a column/field iin an
existing table from Number(long Integer) to Percent.
Click to expand...

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