Convert NULL Values

Hi all,

I am trying to convert all the NULL values in a column to "Open". Any
ideas??

TIATry:

UPDATE MyTable
SET MyColumn = 'Open'
WHERE MyColumn IS NULL

--
Hope this helps.

Dan Guzman
SQL Server MVP

"GuyInTn" <christopher@.NOSPAMreardenweb.com> wrote in message
news:iijstv4n70v7tcqac4t67o5a5k8mpjaopg@.4ax.com...
> Hi all,
> I am trying to convert all the NULL values in a column to "Open". Any
> ideas??
> TIA|||Thanks, I knew it was something simple.

On Tue, 16 Dec 2003 01:22:30 GMT, "Dan Guzman"
<danguzman@.nospam-earthlink.net> wrote:

>Try:
> UPDATE MyTable
> SET MyColumn = 'Open'
> WHERE MyColumn IS NULL