Using AS to pad the column title length should do the trick. Make sure you are using a sufficient amount of padding.
Alternatively, use the -tabdelimited or -commadelimted options, then load the results into a spreadsheet or database tool; or use the ODBC driver. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <[email protected]> wrote on 2005-03-21 08:31:24: > Hmm, I had already tried padding the columns and in the normal > (narrow) mode, it still starts to line-wrap at 18 characters. In wide > mode it then puts it in paragraph mode. > > Ben > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of > Fred Johanson > Sent: Friday, March 18, 2005 7:18 PM > To: [email protected] > Subject: Re: Sql query for file listings. > > Try 'select node_name as "Node",hl_name > as "Directory ", etc.' > > The padding in the AS description serves to widen the column for hl_name > (or whatever else). > > Fred Johanson
