hi,
thank you for every things,

this code mean i get 4500 records only at mytable,
if yes,i want to insert all records to new table

i try to that but i get error message.
Cannot update the cursor "cursor", since it is read-only

CREATE TABLE &lcTableName (char1 C(10), char2 C(70),char3 C(10), char4 C(10),char5 C(10), char6 C(40),char7 C(10), char8 C(10),char9 c(10), fld10 datetime(40),char11 C(10), char12 C(60),char13 C(50), char14 C(40),char15 C(10), char16 C(10),char17 C(10), char18 C(70),char19 C(10), char20 C(10),char21 C(10), char22 C(40),char23 C(10), char24 C(10),char25 C(10), char26 C(70),char27 C(10), char28 C(10) NOCPTRANS)

select * from amar66 where rand() < 4500 / 100000

APPEND FROM (newamar66).

regards.