how to find first occurence of character ina string

[rmgirma]

You could also use
select
substr(phno,1,3) first_field,
substr(phno,5,2) second_field,
substr(phno,7,5) third__field
from table_name