hi,
thank you it works.


>>hi all,
>>
>>i try via this code under to insert what i need exactly , but i get records have space at my table,
>>i mean only char5=="RES"
>>

>>Select * from afm ;
>> where inList( upper(allt(char5)), "RES") ;
>>   into table am2 nofilter
>>

>>
>>thanks.
>
>

>Select * from afm ;
>      where UPPER(ALLTRIM(char5)) == "RES";
>into table am2 nofilter
>