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