Thanks for that nagesh - that command actually gets rid of the output; but that is not what I want.

I want to be able to say justify the first three columns output say justify the value to center or LEFT and not do naything to the rest.

I do not want to have to do this -

select (my first three columns with RPAD's), the rest of the columns
from table

as too many columns to type in .

Is there such a command(s) or way in which I can get the first three columns formatted (values centered) and get all the rest of the columns selected "without" having to type them into the select statement???

[Edited by marist89 on 07-05-2002 at 09:36 AM]