>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=""
Hi Max,
Depending on your settings for ANSI and EXACT, "" will be equal to every character field. Besides EMPTY() which Hilmar mentioned there are ISBLANK() and ISNULL(). You can read in Help to learn more about all of these.
For an example which shows the differences between EMPTY(), ISBLANK() and ISNULL() see
http://fox.wikis.com/wc.dll?Wiki~IsNullIsBlankEmpty~VFP.