Sql update to set field to null

Jeff Martin Jeff Martin Milad Milad 1 1 silver badge 2 2 bronze badges. Care to explain why your answer is better than the others? I mean you post this about almost half a year later. Eppz Eppz 3, 2 2 gold badges 18 18 silver badges 26 26 bronze badges. Emptying the value and clicking enter will not create a NULL value. If the column is a string datatype varchar and the like , it will create an empty string.

If the column is a numeric datatype int and the like it will pop up an Invalid Value error. And so on. NULL is the absence of a value, and is does not mean "blank.

However, to create an empty string, you can always just hit 'anykey then delete' inside a cell. This is the place for advice and discussions 3 3. Sign in to vote. Thursday, December 27, PM. Hi Better to post on VB. David De. Net expert but can you try this? Value Then Regards Satheesh. CloseDate Is Not System. Value Then. Answered by:. Archived Forums. This is the place for advice and discussions 0 1.

Sign in to vote. Hello i whant to update data in database. Sunday, December 26, AM. It works thank you. Justin Cave Justin Cave k 22 22 gold badges silver badges bronze badges.

Mihai Mihai Suraj Kumar 5, 8 8 gold badges 19 19 silver badges 39 39 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.