update table with the word Null

From: "Joe T" <mail@xxxxxxxx>
Date: Thu, 20 Sep 2007 09:49:35 -0400

I am trying to update a table by putting the word "Null" in the all the fields that contain a blank in the floorplan column.
Is this right?

UPDATE Projects (floorplan)
SET floorplan = 'Null'
WHERE floorplan = ''''

Thanks
Joe T

.

Follow-Ups:
- Re: update table with the word Null
  - From: Bob Barrows [MVP]

Prev by Date: Re: A customized install of a Ricoh printer - can it be done?
Next by Date: Re: update table with the word Null
Previous by thread: Re: How to change password for meny user?help my
Next by thread: Re: update table with the word Null
Index(es):
- Date
- Thread

Relevant Pages

Re: update table with the word Null
... Joe T ... Null values are different from empty (zero-length) strings. ... the fields that contain a blank in the floorplan column. ...
(microsoft.public.scripting.vbscript)
Re: update table with the word Null
... UPDATE Projects (floorplan) ... SET floorplan = 'Null' ... Please reply to the newsgroup. ...
(microsoft.public.scripting.vbscript)
Re: update table with the word Null
... the fields that contain a blank in the floorplan column. ... SET floorplan = 'Null' ... Why haven't you tried this in a test database? ... Please reply to the newsgroup. ...
(microsoft.public.scripting.vbscript)