how to find first occurence of character ina string

[rani]

In my table i have PHONE NUMBER column.
the data of this is like 123-23-34567.

i want to retrive this phone number into 3 separate field of form module.
example : phno=123-23-34567 then
1st field 123
2nd field 23
3rd field 34567