>kem >net >Lod >>im trying to like take the name out of that view and add a number to it so ill have kem001
local lnI lnI = 0 select myView scan lnI = m.lnI + 1 replace myField with alltrim(myField) + padl(m.lnI,3,'0') endscan *------------------------------ alternative solution (assuming no deleted records) replace all myField with alltrim(myField) + padl(recno(),3,'0') in myView