Thanks Steve and everyone for the replies. These queries were extremely helpful!

All,

Thanks a bunch for the help. Looks like everyone's replies got me what I was looking for. I did have one follow up, and i'll edit the original post if...

Ahh. Sorry about that. Here ya go:

CREATE TABLE temp_docs (
begval VARCHAR(100)
,endval VARCHAR(100)
,volume VARCHAR(20)
,prefix varchar (50)
,padding INT
,begnum VARCHAR(50)
,endnum VARCHAR(50)
)
GO


insert into temp_docs (BegVal, EndVal, Volume, Prefix, Padding, begnum, endnum)
values(...

That! is a valid question Dixie. I'm new to using SQL server regularly so saw an sample cursor that I could easily adapt and used it. Appreciate the simplification!

Large amount of email recipients (> 5000 per row). Final count of split values was ~73 million records

@thom-2 A -- Thank you for the suggestion! I was able to achieve my goal. For anyone looking to do something similar in the future, here's what I...

@Ant-Green -- Thanks for the info! While this works well, like I said, I have input strings that are up to 314,000 characters long, and this looks to only parse...