Good day everyone!
I am trying to code a button that when pressed will look through a field and if it finds any empty fields in the table replace it with a default value.
I was thinking something like the following but I know it's wrong:

REPLACE ALL table.field with "default_value" where table.field=""

Can anyone please help with the proper syntax? Thanks!
Max