Re: How to do linefeed in SQL?

[Quoted] On Fri, 21 Feb 1997 11:45:33 GMT, teetshd_at_ucbeh.san.uc.edu (greg teets) wrote:

>This seems like it should be pretty simple but I can't see how to do
>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,
> city||', '||state||' '||zip
>from customer;
>
>Thanks,
>Greg

I found "NEWLINE" under the column parameter. Easier done than found. <g>

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