Splitting string into coloumns

[Anonymous]

Hi Friends,

I have a string like b-bghy-gnhytr-df-fgt.Need to split into 5 coloumns.

As well its size is not fixed..

Can any one help on this..

[venkat1]

i tried this but creating synthetic tables.