>I have discovered that there are some blank fields in one of my tables.
>
>The numeric field in question has never had a numeric(or any other)value written to it.
>
>I have tried
>
>
>DELETE FOR x = .null
>
>
>but that code does not work for me. How can I globally mark the blank field records for deletion?
>
>+++ Grady ---
In this case the value is not null. As others have pointed out, you can use the empty function; if the value is really NULL, you can check for isnull(...). A comparison of x = NULL will always give false, even if x is really null!
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
