>>Hello everybody,
>>
>> I got very interesting problem and can't solve it... Whenever I try to run
>> following SQL statement:
>>
>>
>> SELECT xgts.rtgts_leit FROM gts0can be used for this case? I got only one thought to made severall SQL's to
>>reduce number of items within IN clause, but maybe there are other ways to
>>skin a cat?
>>TIA
>
>Vlad,
>
>Here's another potential solution (although not ANSI standard). Store the values in an array and use
>
>WHERE ASCAN(a_numbers, xgts.rtgts_leit) # 0

Thanks, I got it to work with nested selects