Re: update table with the word Null
- From: "Joe T" <mail@xxxxxxxx>
- Date: Thu, 20 Sep 2007 10:05:27 -0400
Access database. Yes Null values are allowed.
Null values are different from empty (zero-length) strings. I know that.
Joe T
"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message news:uG7GX44%23HHA.1184@xxxxxxxxxxxxxxxxxxxxxxx
Joe T wrote:I am trying to update a table by putting the word "Null" in the allIt depends:
the fields that contain a blank in the floorplan column.
Is this right?
UPDATE Projects (floorplan)
SET floorplan = 'Null'
WHERE floorplan = ''''
What database are you using?
Is floorplan configured to allow Null values? Null values are different
from empty (zero-length) strings.
Why haven't you tried this in a test database? You could have had your
answer already ...
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- Follow-Ups:
- Re: update table with the word Null
- From: Joe T
- Re: update table with the word Null
- References:
- update table with the word Null
- From: Joe T
- Re: update table with the word Null
- From: Bob Barrows [MVP]
- update table with the word Null
- Prev by Date: Re: update table with the word Null
- Next by Date: Replace file if smaller in size
- Previous by thread: Re: update table with the word Null
- Next by thread: Re: update table with the word Null
- Index(es):
Relevant Pages
|
