Re: null character

From: "Arnie Rowland" <arnie@xxxxxxxx>
Date: Thu, 6 Jul 2006 17:25:22 -0700

UPDATE MyTable
SET ColToUpdate = NULL

--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."

"panda" <panda@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:60C3ACEE-5652-4526-A3E7-7330871A3302@xxxxxxxxxxxxxxxx

Hi,

How do you write a sql statement to update a column to be of <null>?
What is the syntax?

If have tried "null" and \0

thanks

Prev by Date: Re: A Bug about SQL Query Analysis(SQL 2000 AND SQL Server 2005)
Previous by thread: Re: A Bug about SQL Query Analysis
Index(es):
- Date
- Thread

Relevant Pages

Re: Download worksstaion components
... Arnie Rowland* ... "To be successful, your heart must accompany your knowledge." ...
(microsoft.public.sqlserver.clients)
Re: User Not Listed for Permissions on a View
... Arnie Rowland* ... "To be successful, your heart must accompany your knowledge." ...
(microsoft.public.sqlserver.security)
Re: SQL server compare utility
... Arnie Rowland* ... "To be successful, your heart must accompany your knowledge." ...
(microsoft.public.sqlserver.tools)
Re: How do i find the logical file name
... Arnie Rowland ... "To be successful, your heart must accompany your knowledge." ...
(microsoft.public.sqlserver.msde)
Re: Multiple Instances
... Arnie Rowland* ... "To be successful, your heart must accompany your knowledge." ...
(microsoft.public.sqlserver.setup)