sql print statement?

Question

In SQL I am trying to execute a print statement to list a set of students, which looks like this:
STUDENTS
FIRST LAST
john doe

What I want to do it underline the words STUDENTS, FIRST, and LAST without having to do another print '____' '____' , which is not verty neat looking. Is this possible, if so can someone show me how.
The print statement for STUDENTS looks like this:
print 'STUDENTS'

Correct it is the Query Analyzer I am using however that is all we are using for printing the content on screen, it's not being generated to print out on hard copy. But judging by your answer theres no way to do it correct ?

Answer 1

I am an expert at this, and, given the meager context (i.e., I assume you are working in Query Analyzer or SQLPlus), I wouldn't know any other way. SQL is for managing data, not formatting output. For that, you'd rightly use a report writer, or retrieve data into a document of some sort.

Answer 2

you will ought to inner connect on all 3 tables (TextBooks, Authors and Publishers) on the TextBookEditions. Assuming the QtyPrinted is a NON 0 quantity (if no longer you will ought to put in a the place QtyPrinted >0 interior the sq.. you may do inner connect on Authors to TextBookEditons and then inner connect from TextBookEditions to the different 2 tables. in case you come back merely the Authors call, do a opt for distinctive to easily return the authors call as quickly as

Answer 3

Agreed.

SQL selects the data......your report generator, such as Crystal Reports will be used to format your data.