CREATE CURSOR test (C1 C(10))
CREATE CURSOR Test2 (C1 C(10))

FOR asd = 1 TO 50
    IF asd < 26
       INSERT INTO Test2 VALUES (TRANSFORM(asd))
    ELSE
       INSERT INTO Test2 VALUES (TRANSFORM(asd-25))
    ENDIF
NEXT

INSERT INTO Test (C1) SELECT DIST C1 FROM Test2 GROUP BY c1
SELECT Test
BROW