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