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