hi,
convert all fields to zeroz,character type and numaric type???
thanks
>

>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