How concat string
R. RoyalNov 14 2006 — edited Nov 14 2006Hi,
I've table TAB_COD
COD_ID.................NOTE
001....................OK
001....................NOT OK
001....................YES
002....................TOP
005....................X
005....................Y
005....................Z
007....................MY
007....................YOUR
008....................STOP
I'd like to get this output:
COD_ID.................NOTE
001....................OK - NOT OK - YES
002....................TOP
005....................X - Y - Z
007....................MY - YOUR
008....................STOP
How can I concat string group by COD_ID?
Thanks in advance!!