>>Hi,
>>
>>Thanks for the suggestions.
>>
>>I tried will all these methods, but could not succeed. However the query which I am trying to evaludate is having about 90 plus columns. If I try to reduce number of columns to about 70, then it evaluates without problem.
>>
>>Is there any way out for this ?
>
>You might try increasing the value for SYS(3055); see the on-line help for details. This increases the number of fields that can be processed in a SQL statement of FOR clause; the default is 320 and maximum is 2040; I'd start in the 800 range for your situation, based on the suggested formula in the on-line help.

Hey Ed - never knew about this one - Thanks!