Handling The Text Data Type

  • 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.

  • Well done, Robert!

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

  • 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!!


Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply