Empty fields

[BPMan]

I have a table that about 2,000 records.
some of the fields in this record only have a few things in them.....
i want to set all the empty cells in the field equal to something and leave the other cells alone.....how can i do this... i assume it is something like
UPDATE table SET table.field = ? WHERE table.field = NULL;
or something like that buy what do i put in the place of NULL
thanks

 

[zambezibill]

UPDATE Table SET Table.YourField = "999"
WHERE (((Table.YourField) Is Null));

Cheers, Bill