This should be simple but I can't figure it out....
I have a large table that contains NULL values and values like €0,00 in a field with the name price. I need to replace these values with €0,01
So I thought my rusty sql knowledge and google could help me solve this, but I am stuck...
To remove the null values I used the query:
Code:
UPDATE tblItem
SET tblItem.prijs = "€0,01"
WHERE (((tblItem.prijs) Is Null));
and that worked well to remove the NULL values and changed them to €0,01
good
So I thought this would work to change €0,00 to €0,01
Code:
UPDATE tblItem
SET tblItem.prijs = "€0,01"
WHERE (((tblItem.prijs) Is "€0,00"));
But it does not and I am puzzled why... It must be something very obvious that I am overlooking, but what?