Handling The Text Data Type

• bdavey

  Default port

  Points: 1469

  More actions

  March 27, 2009 at 2:12 pm

  #967736

  Thanks for posting that. I noticed the same thing but thought I had missed something.

  Any idea what the alternative is? I expect using SUBSTRING.

• wonder6789boy

  Grasshopper

  Points: 13

  More actions

  May 4, 2009 at 1:02 am

  #987950

  Well done, Robert!

  Thanks for sharing your knowledge - it really saved when working on a clients' old SQL 2000 Server!

• pt9s

  SSC Veteran

  Points: 296

  More actions

  October 11, 2010 at 3:07 pm

  #1235225

  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