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
from customer;
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