Setting default values

how do you set a default value of 0 to a field type of "Real" using sql

E.g. ALTER TABLE TB ADD COL REAL DEFAULT ?

"TC" <bob@bob.com> wrote in message news:3fd90147$1@wic040d....
> how do you set a default value of 0 to a field type of "Real" using sql
>
> E.g. ALTER TABLE TB ADD COL REAL DEFAULT ?
>

ALTER TABLE <TableName> ALTER COLUMN <ColumnName> SET DEFAULT 0;

- Per