> Hi Adam
>
> Is there any remidy to overcome the above problem.
>
> Thanx
> Sathiesh
>

Not the way you are attempting to solve whatever problem you are
solving. There is an implementation limitation you are hitting in the
number of fields that can be included in a sort, and a sort is
required to do the distinct.

Perhaps explaining the problem you are trying to solve may allow us to
propose another solution, but all software has design limitations,
this is just one of Firebirds.

Adam