>select unemp_ins_pct ; > from payroll_tbl ; > where unemp_ins_pct # 0 ; > into array a__gen40 ; > order by payroll_tbl.id > > If vartype(a__gen40) # 'U' and vartype(a__gen40) # 'L' > b1 = alen(a__gen40) > if b1 = 1 > .q1 = (a__gen40(1,1)) &&latest unemp_ins_pct > else > .q1 = (a__gen40(b1,1)) &&latest unemp_ins_pct > endif > else > .q1 = 0 &&latest unemp_ins_pct not found > endif > release a__gen40 > Try Select Top 1 unemp_ins_pct ; From payroll_tbl ; Into Array a__gen40 ; Where unemp_ins_pct > 0 ; Order By payroll_tbl.id Desc