create cursor mycursor (year i,saled i) insert into mycursor values (1999,1000) insert into mycursor values (2000,1200) insert into mycursor values (2001,1800) insert into mycursor values (2002,900) insert into mycursor values (2003,2700) insert into mycursor values (2004,5400) insert into mycursor values (2005,540) alter table mycursor add column growth n(5,2) SELECT MyCursor m.lnOldYear=MyCursor.Saled SCAN mychange=MyCursor.Saled- m.lnOldYear ipercent=100*mychange/m.lnOldYear REPLACE MyCursor.growth WITH ipercent m.lnOldYear = MyCursor.Saled endscan