fantastic, thanks Thom this looks to have solved it.

much appreciated.

Thanks Thom, I used the DelimitedSplit8K described by Jeff Moden - http://www.sqlservercentral.com/articles/Tally+Table/72993/

I get the results below:

A
A > C
A > A > C
A...

that's a great suggestion - thanks.