>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

create cursor temp (sno n(4))
for i=1 to 2500
   insert into temp (sno) value (i)
endfor
insert into 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.