Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Updating Rows problem

Author  Topic  hameed Starting Member 40 Posts Posted - 2001-11-08 : 06:13:51 I need to update all rows in a table where a specific field has a <NULL> value in it. This is my code: UPDATE CaseRecords SET case_County = 'napa' WHERE case_County = ' ' but I can't get it to work. I have tried: WHERE case_County = '' and WHERE case_County = null and WHERE case_County = <NULL> with no luck. Please tell me what I am doing wrong.