Dear All,

can oracle sql grouping the data by substring?

my data as below:-
AM17040041200
AM17040041GEVE5--100X025D
AM17040041GEVE7--100X016D
AM17040041GEVE7--100X025D
AM17040041GEVE7--220X016D
AM17040095200
AM17050041200
AM17050041GEVE7--101X010D
AM17050041GEVE7--220X016D
AM17050041GEVE7--220X025D
AM17050041GEVE7--330X016D
AM17050041GEVE7--470X016D


i want to group into
AM17040041, AM17040095, AM17050041
Best Regards
Terence Chua

Oracle LazyDBA home page