Splitting strings in SQL

Question

Post reply

Splitting strings in SQL

nairdeepa

Ten Centuries

Points: 1296
More actions
February 10, 2012 at 3:35 am

#255301

Hello,
I need to split the below string:
'Spring 2012,Spring 2011'
as
'Spring 2012','Spring 2011'
Does any one know how to do this ?
Thanks,
Debra

Viewing 6 posts - 1 through 5 (of 5 total)

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

nairdeepa Ten Centuries Points: 1296 More actions · Answer 1

Also please note I dont want it to be a table. Thanks.

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

nairdeepa (2/10/2012)
Hello,
I need to split the below string:
'Spring 2012,Spring 2011'
as
'Spring 2012','Spring 2011'
Does any one know how to do this ?
Thanks,
Debra

Try Jeff Moden's string splitter function, by far the fastest purely SQL method to date[/url].

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/

nairdeepa Ten Centuries Points: 1296 More actions · Answer 3

nairdeepa

Ten Centuries

Points: 1296

February 10, 2012 at 4:20 am

#1445448

Thanks. Do you have link to it?

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

nairdeepa (2/10/2012)
Thanks. Do you have link to it?

My whole post was a link to the article[/url] describing it. The article includes the code.

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/

nairdeepa Ten Centuries Points: 1296 More actions · Answer 5

nairdeepa

Ten Centuries

Points: 1296

February 10, 2012 at 4:55 am

#1445464

okay thanks.