I am looking at an SQL database table where one thing I have found is I have a Folder path. I would like to split it out but have come to realise I have never even thought about splitting a field in a database before.

Effectively I have

Col 1, Col 2, Server, Path, Col 4, Col 5

What I would like is

Col 1, Col 2, Server, Parent, Child Lev 1, Child Lev 2, Col 4, Col 5

Unfortunately I have no set level either. so some folders obviously will be 1 level, others will be 9 others may be 15.

Any help would be apreciated.