SQLServerCentral / Discuss Content Posted by Leo Peysakhovich / Article Discussions / Article Discussions by Author / Manipulating Data in TEXT Type Columns / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 18:16:44 GMT20RE: Manipulating Data in TEXT Type Columnshttp://www.sqlservercentral.com/Forums/Topic235034-163-1.aspx<FONT face=Arial> </FONT><P>Great article.</P><P>But it looks like there is an error in a code.</P><P>If XML tag happens start right before position 8000 (or multiple of) it will not be found.</P><P>This may be a fix:</P><P>Set @parsedlen = @parsedlen + 8000 - len(@parsedval)+1</P><P> </P>Thu, 07 Dec 2006 07:17:00 GMTDmitry KorsunskyRE: Manipulating Data in TEXT Type Columnshttp://www.sqlservercentral.com/Forums/Topic235034-163-1.aspx<P>Agreed, TEXT datatypes are like other datatypes as chalk is like cheese.</P><P>However interesting article, a shame it was hard work to read.</P>Fri, 09 Dec 2005 15:41:00 GMTStuart DavisRE: Manipulating Data in TEXT Type Columnshttp://www.sqlservercentral.com/Forums/Topic235034-163-1.aspxMan! This is the first time I've EVER heard anyone say "For many SQL Server 2000 DBAs working with text columns in T-SQL is no different than any other datatype." Lol!Great article though, thanks.Wed, 07 Dec 2005 16:25:00 GMTJohn ScarboroughManipulating Data in TEXT Type Columnshttp://www.sqlservercentral.com/Forums/Topic235034-163-1.aspxComments posted to this topic are about the content posted at <A HREF="http://www.sqlservercentral.com/columnists/lPeysakhovich/manipulatingdataintexttypecolumns.asp">http://www.sqlservercentral.com/columnists/lPeysakhovich/manipulatingdataintexttypecolumns.asp</A>Thu, 03 Nov 2005 16:25:00 GMTLeo Peysakhovich