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)
>>>>***
>>>> DELETE all
>>>> pack
>>>>endscan
>>>>
>>>>
>>>>thanks