Re: Is there way, i can display query results in column-wise/ Horizontally ?

ravi kumar wrote: > Hello, > > Below is my requirement. Is there any way i can acheive that? > > If i fire the query " Select * from customer ", the o/p is like > below(display is vertical): > > Customer_no : 101 > Fname : Ravi > Lname : Kumar > ... > ... > ... > > My requirement is to display the results in horizontal way, like below... > > Customer_no Fname lname ... > ------------------ ---------- --------- > 101 Ravi kumar > 102 Ajay xyz > .... > > Thanks in advance for all your assistance. > > Regards, > Ravikumar. > SQSL (see my sig) will do that and much more -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm