select myTable
local lnI
local array laFields[1]
afields(laFields)
for lnI = 1 to alen(laFields,1)
    blank for empty(&laFields[lnI,1])
next

From the top of my head.

>hi how are you,
>mean
>

>USE mytable
>SCAN FOR FIELDS=0
>REPLACE ALL FIELDS WITH balnk
>*BLANK for Fields = 0 in myTable
>ENDSCAN
>

>
>>>hi all,
>>>i need to replace space to my table where i found zero?
>>>

>>>USE mytable
>>>SCAN FOR FIELDS=0
>>>REPLACE ALL FIELDS WITH SPACE()
>>>ENDSCAN
>>>

>>>thanks
>>
>>You can not do it, since the numeric field can not be replaced with character.
>>
>>You can use BLANK command instead, e.g.
>>
>>BLANK for Fields = 0 in myTable