Update a field to a null value

[Young]

How do I set a field to a null value in the UPDATE statement?

Eg. To update a text

UPDATE [CLIENT] SET [Name] = 'X'

But if I want to set it to null, what is the syntax?

TIA

JK

 

[Jan Hyde]

"Young" <[email protected]>'s wild thoughts were
released on Tue, 30 May 2006 08:51:08 GMT bearing the
following fruit:

How do I set a field to a null value in the UPDATE statement?

Eg. To update a text

UPDATE [CLIENT] SET [Name] = 'X'

But if I want to set it to null, what is the syntax?

= NULL



Jan Hyde (VB MVP)

 

[Mark Rae]

UPDATE [CLIENT] SET [Name] = 'X'

UPDATE [CLIENT] SET [Name] = NULL