I am trying to concatenate several fields to insert data into a memo field in a new table. The issue is just that I want to add an "end line" at the end
of each field so that the memo comes up with each field on a new line.

i.e. Here is the code I have:


INSERT INTO NewCustomer
(
/* other fields listed here */
AddressMemo
)

SELECT
(
/* other fields listed here */
Address1+ " " + Address2 +  " " + TownCity + " " + PostCode as AddressMemo
)

FROM OldCustomer

--

I want to put something in place of the + " " + sections so that I end up with a multi-line memo field ...

Adam

adam


I think its just 'fred'+#13#10+'Bert'

I can't check at the moment - busy installing D2006

Why not just reverse engineer a 1 row table with that in, select to have data and have a look?

Roy Lambert