sqlplus column underline

From: <cwass_at_dacotah.com>
Date: Fri, 08 May 1998 21:36:00 GMT
Message-ID: <6ivts1$227$1_at_nnrp1.dejanews.com>

[Quoted] I have a comment field that I am selecting for a report. I am trying to get [Quoted] the underline off the comment but not the rest of the fields.

I'm doing this:

COLUMN Comments newline heading '' format a40

SELECT Location, Resdate, Restime, Name, Comments FROM Reservation
WHERE somecriteria;

And I'm getting this: (whithout the line of '+')

++++++++++++++++++++++++++++++++++++++++++++++++++

Location Resdate Restime Name

-------- --------- ------- --------------
-----------------------------------------
BALT130  10-MAY-98 12:00   JOHN DOE

comments for john doe party appear here

BALT130 10-MAY-98 12:00 JANE DOE
jane doe comments appear here

++++++++++++++++++++++++++++++++++++++++++++++++++

[Quoted] I want the comments to show up on the next line like they are doing. How do [Quoted] I get rid of the long line of '-'? SET UNDERLINE OFF is all or nothing. I need underlines under the other fields.

Any ideas?

TIA Craig

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 08 1998 - 23:36:00 CEST