使用Substring & patindex将字符串的一部分提取到新的列MS SQL中

I have a field in MS SQL that is concatenated like this TopLevel>MidLevel>Lowestlevel tis string varies in length. Sometimes the string is shorter with only a topLevel or a toplevel>MidLevel What I need to do is take the string apart at the ">" and put the text in between into new columns/fields. I tried parsename which worked great until the length started changing. I have a field in MS SQL that is concatenated l