It depends.

if you like to delete records that look like SPACE(70)+'any other non blank string'; ISBLANK() may fail. ::)

Agnes
>thank you very much,
>DELETE FOR ISBLANK(no)&&this is better
>
>
>>

>>DELETE FOR no=SPACE(70)
>>*or
>>DELETE FOR ISBLANK(no)
>>

>>>hi all,
>>>
>>>i try to delete empty records form my table after i convert excel sheet to dbf,
>>>
>>>is there another way to do that as
>>>
>>>IMPORT FROM (thisform.text11.value) TYPE xls&&delete all empty records
>>>
>>>i try as
>>>

>>>SCAN
>>>  SET FILTER TO  no=SPACE(70)&&work
>>>***&&no="" not work,no=space() not work
>>>     DELETE all
>>>     pack
>>>endscan
>>>
>>>

>>>thanks