Thank you, Steve.   greatly appreciated!

here is the text versions:  fulltxtstring is what i start with;  parsedtxtstrings is the required split results

thanks much for your help.

thanks for the Response Sean.  attaching sample data

Hi Jeff.

your tally table approach to parsing is the best i've seen.   i have a real world problem;  wondering if you have any thoughts.

i need to parse a large clob/text...

would it be easier (more accurate) to calculate age in months and divide by 12?

select cast( datediff( month,'08-21-2008',getdate()) as decimal)/12