Split A Folder Path
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.