>Yes, this code will make all empty data (character, numeric, date) to be blank.
>If you want numeric only to be blank, you can check for field type in the loop laFields[m.lnI,2] = 'N'
>
>>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

>>>

Actually, it would blank the whole records. You probably wanted

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