>>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!

Thanks Hilmar.

+++ Grady ---