changing the formatproperty using SQL

[Beginner]

How do I change the formatproperty of a column/field with
the Number fieldtype (from double to currency) in a SQL
statement ?

Do I use Alter column as below ? How do I incorporate the
change in format property ?
ALTER TABLE ZBILLINGNEW ALTER COLUMN [fieldname] Number

Please Help

Thanks in advance

 

[Bryan]

Beginner,

Yes, it sounds like you have the appropriate syntax. Here
it is again:

ALTER TABLE <table name>
ALTER COLUMN <column name> <data type [(<precision>)]>

An example of settting changing a column's data type to a
varchar of length 25 would be:

ALTER TABLE tblMyTable
ALTER COLUMN MyColumn varchar(20)

Bryan