Hi

Thank you so much for this very informative article.

I have been trying to analyze the windows registry with SQL Server and found some lines to be over 60 thousand characters long!

I would like to chop the long lines into 2000 character segments and put it into a new table with the original rowID, segmentID, and the 2000 characters in a varchar field.

With what you've shown I think it will work.

Thanks so much!!

Conrad