Re: FW: Query

It could be done, but you must know the exact number of columns, if so then You can use decode to achieve what you want. If the number of columns is not know then I don't know, althoug in this case I think that could not be done using normal SQL. J. shahid.mehmood escribis: > I want the return rows into columns, like > > > > The return rows in a select > > 1 > > 2 > > 3 > > 4 > > 5 > > > > Appear as > > 1 2 3 4 5 > > > > Is it possible? > > > > Thanx, > > S m > sending to informix-list sending to informix-list