How to create a recursive join where parent and child are store in same field. Consider below example:

SF-AIRPORT (Parent)
SF-AIRPORT/192 AIRFIELD ENGINEER (child)

Query needs to find out all the child elements for the parent (In above example all child are concatenated by / in the above example for parent SF-AIRPORT)

I was trying to use SUBSTR AND INSTR functions with little success

Any help or pointers

You need to fix your database design, then you can use CONNECT BY