for this case it works,
thanks

>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