Split String

Question

Split String

kyle.doouss

SSCommitted

Points: 1513
More actions
January 25, 2012 at 3:31 am

#267204

I am wanting to split a string which can be a Max chars of 60 but not cut a word in half.
If you don't know what I mean please say
Glad of any help

Viewing 4 posts - 1 through 3 (of 3 total)

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

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

kyle.doouss (1/25/2012)
I am wanting to split a string which can be a Max chars of 60 but not cut a word in half.
If you don't know what I mean please say
Glad of any help

Try Jeff Moden's string splitter. You can find the code and the article explaining it here --> http://www.sqlservercentral.com/articles/Tally+Table/72993/%5B/url%5D

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Brandie Tarvin SSC Guru Points: 173045 More actions · Answer 2

Ditto to Jeff Moden's version. It is probably the best, and most highly recommended, splitter code I've seen.

And it works.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

brendan woulfe Hall of Fame Points: 3888 More actions · Answer 3

I will be the third to say go with Jeff's splitter. I created my own splitter function before finding the link posted above and not only was Jeff's waaayyyyy faster and more efficient, it was a lot easier to read and understand too.