I have a data as below:

ID DetailID from To

1   202          A        B
2   202          B        C
3   202          C        D
4   202          D        E


I would like to combine it as "A/B/C/D/E" into a single value for 202(DetailID).

result that I needed:

DetailID from/To
202       A/B/C/D/E    


Thanks in advance.

Edited by amender - 13 Jan 2013 at 10:53pm

Hi