>Hi all
>How can I create cursor with IDS from 1 to 100 for stickers.
>I need that my first sticker will be 001, the second 002 etc (not 1,2).
>Thank for help
CREATE CURSOR crsTemp ( sticker C(3))
FOR i=1 TO 100
INSERT INTO crsTemp VALUES( PADL(i,3,"0"))
ENDFOR
--sb--