How to do linefeed in SQL?

From: greg teets <teetshd_at_ucbeh.san.uc.edu>
Date: 1997/02/21
Message-ID: <330d20fb.20393707_at_news.ececs.uc.edu>#1/1


[Quoted] [Quoted] This seems like it should be pretty simple but I can't see how to do [Quoted] it from the books.

If you wanted to make address labels using each column as a row on the label, what would you add to the following SQL to make the necessary linefeeds when the column changes?

select salutation||' '||first_name||' 'last_name,

          address_1,
          address_2,
[Quoted]           city||', '||state||' '||zip

from customer;

Thanks,
Greg Received on Fri Feb 21 1997 - 00:00:00 CET

Original text of this message