Hello,

We are running MS SQL Server 2000 as the backend for our ERP system. The customer database stores the customer address (ie. 1,2&3) as a single record with carriage returns and linefeeds, rather than breaking it into separate records. I am trying to write a query that will break the address field into a field for each line (at the carriage return or linefeed) so that we can link the UPS shipping computer directly to a OBDC query view of our sales orders.

The record currently looks something like:

Address:
Attn. Purchasing
Biggy Corporation
123 Some Street

I want it to look like:
Address1:
Attn. Purchasing
Address2:
Biggy Corporation
Address3:
123 Some Street

If someone could give me a few pointers or examples to work with on this, It would really save my neck.

Thanks A lot