It depends on where the data you want to inset is... you can do something like...

INSERT INTO MyTable SELECT * from ThisTable WHERE ...

BOb

>Hi,
>
>Anyone knows if it's possible to make a cycle in SQL "language"?
>
>With VFP:
>
>For i = 1 to 500
> Insert into myTable(....
>Next i
>
>With SQL:
>
>???
>
>
>Thanks,
>
>Ricardo