update table set yourcolumn=null

Have you read the manual? :-)

Artur

----- Original Message -----
From: "Stevio" <redeagle@...>
To: "IB Support" <ib-support@yahoogroups.com>
Sent: Tuesday, July 02, 2002 5:41 PM
Subject: [ib-support] Setting all values for a column to null


> Is there an easy way in SQL to set the value of a column for all records
to
> null?
>
> I don't want to delete the column, just blank all the values that are
there.
>
> Thanks,
> Stephen
>