Change WHERE to FOR. And note that Jos did not try to solve your problem, he only wanted to push you in the right direction.
>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)), "ÞØÇÚ ÇäÙãÉ ÇáãÚáæãÇÊ")
>>