-
Carriage Returns and Line Feeds
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|