Hello!

I am generating a CSV file to import contacts into Outlook
(various versions).  The data come from an SQL database
where street 1, street 2, and street 3 are in separate
columns.  I would like to combine those three columns into
one field, which Outlook calls Business Address, and I'd
like to concatenate the three values with carriage returns
in between.  How do I add the return?  

I've tried SQL like so: select street_1 + <delim> +
street_2... (very simplifed version of my actual
statement) and my question revolves around which is the
proper <delim> to use.

When I use char(13) and/or char(10), the CSV file breaks
the column so hard that even Excel can't tell that the
values belong to one column, but instead creates new rows.

When I use '\n' and/or '\r', Excel and then Outlook treat
that like plain text; I get addresses on one line, with
\n's and \r's interspersed.

What is the proper way to indicate a 'soft' return?

(I've looked at the results of 'Export from Outlook to
CVS', but there, the soft return is shown as a rectangle
which I am unable to deciphre.)

Thanks in advance for any suggestions.

Simon