update fields.

[Danden]

Hello,
I have a fields in column "description" which are empty and I want to update them with the data for example "D2".

Why this does not work?

update dbo_Zones set description ='D2' where description=""

 

[pbaldy]

Try


update dbo_Zones set description ='D2' where description Is Null

 

[Danden]

Thank you for tip.

 

[ChristopherL]

update dbo_Zones set description ='D2' where description=" "

worked for me, I just added a space between your "" so " " instead

 

[pbaldy]

Danden: happy to help

ChristopherL: That would only work if the field contained a single space, which would be unusual in my experience. Most common would be Null or a ZLS ("").