hi All,
my data is so bad that the emailaddress got split into different rows with all the same other details.
eg:
order_nbr emailaddress seq_id
100 Y, 6
100 DSkkk@yahoo 7
100 .com 8
i have the column seq_id which has the consequent nos for the continuation.
now i have to concatenate the whole email address and discard the remaining rows.
i have done an order by through my SQL query and have all the rows in this fashion in order. now i am to concatenate them when they have all order_nbr same.
can you suggest different ways to do this?
concatenating same column data
Moderators: chulett, rschirm, roy
concatenating same column data
g.kiran
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom