Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Leo Peysakhovich Manipulating Data in TEXT Type Columns RE: Manipulating Data in TEXT Type Columns
Dmitry Korsunsky
Valued Member
Points: 56
More actions
December 7, 2006 at 7:17 am
#676589
Great article.
But it looks like there is an error in a code.
If XML tag happens start right before position 8000 (or multiple of) it will not be found.
This may be a fix:
Set @parsedlen = @parsedlen + 8000 - len(@parsedval)+1