>Dear Experts > >Table1 has only one numeric field as sno n(4) > >It has records as > >1 >25 >1500 >1800 > >In sno field, I want to insert missing records between 1 to 2500. > >Please help
Something like
createcursor temp (sno n(4))
for i=1to 2500
insertinto temp (sno) value (i)
endforinsertinto yourtable select sno from temp;
where sno not in (select sno from yourtable)
The code doesn't need to know which records already exist in your table.