Thanks all

i already found the solution. ^_^

Best Regards
Terence Chua
----- Original Message -----
From: "Terence Chua"
<oracledba-ezmlmshield-x11999385.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, January 09, 2008 10:27 AM
Subject: grouping sub string


> 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
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>



Oracle LazyDBA home page