perfect Borislav, worked like a dream.
Slán
~M
>>hi all,
>>i have a table and thousands of records in it. i want to delete any record with no entry in a field but i don't know how to do it. the field is a numeric field and i want to only delete the records that have nothing in it but not those with a 0. i have tried brow for field = .NULL. and empty(field) to see what would be deleted but this won't do. any help much appreciated.
>>Slán
>>~M
>
>
>DELETE FROM MyTable WHERE ISBLANK(MyField)
>** or
>SELECT MyTable
>DELETE FOR ISBLANK(MyField)
>
Go raibh maith agat
~M