hi,
sorry to bother you again,
i try to append random records as under ,not works

total = 300
RAND(-1)
INDEX ON RAND() TO SYS(2023)+'\RANDOM'
*COPY TO moh111 NEXT &total
APPEND FROM rami3 for  upper(allt(sec_txt))=="ÞØÇÚ ÇáÔÄæä ÇáÝäíÉ æÇáÊÒæíÏ" NEXT &total                           

SET INDEX TO
ERASE SYS(2023)+'\RANDOM'

thanks
>With all due respect Mohammed but did you even spend 2 seconds to try and understand why?
>
>>hi,
>>thank you for reply
>>i get error message
>>Command contains unrecognized phrase/keyword
>>
>>thanks.
>>>>hi all,
>>>>
>>>>any idea , help
>>>>i try to append new records to mytable, as under
>>>>
>>>>

>>>>Select * from rami3 ;
>>>> where inList( upper(allt(sec_txt)), "ÞØÇÚ ÇäÙãÉ ÇáãÚáæãÇÊ                                   ") ;
>>>> append blank;
>>>>   into table rami4 nofilter
>>>>

>>>>thanks
>>>
>>>You are mixing your SELECT with your APPEND. Rather do something like:
>>>
>>>

>>>SELECT rami4
>>>APPEND FROM rami3 WHERE inList( upper(allt(sec_txt)), "ÞØÇÚ ÇäÙãÉ ÇáãÚáæãÇÊ")
>>>