One Sql question : how to split string in sql ???

[htnamus]

[quote author=galigannarao link=topic=236410.msg2943181#msg2943181 date=1315849225]
atta raa dariki @3$% @3$% @3$%
[/quote][img]http://[img]http://www.desigifs.com/sites/default/files/dobbeyi.gif?1290232491[/img][/img]

[Antaraatma]

[quote author=HS link=topic=236410.msg2943183#msg2943183 date=1315849247]
[img]http://[img]http://www.desigifs.com/sites/default/files/dobbeyi.gif?1290232491[/img][/img]
[/quote][img width=160 height=120]http://www.desigifs.com/sites/default/files/dobbeyi.gif?1290232491[/img]

[gvkishore.kish]

[quote author=Antaraatma link=topic=236410.msg2943191#msg2943191 date=1315849319]
[img]http://www.desigifs.com/sites/default/files/dobbeyi.gif?1290232491[/img]
[/quote]

Hi Mama...whats up.................

[galigannarao]

[quote author=HS link=topic=236410.msg2943183#msg2943183 date=1315849247]
[img]http://www.desigifs.com/sites/default/files/dobbeyi.gif?1290232491[/img]
[/quote] *7*^ *7*^ *7*^ *7*^ giffu sariga veyyala jaffa

[Antaraatma]

[quote author=gopichand-No1 link=topic=236410.msg2943198#msg2943198 date=1315849353]
Hi Mama...whats up.................
[/quote]hi gopi baa... em ledu baa.. ikkada db lo  sSa_j@il .. wasup wid u.. em chesav weekend..

[htnamus]

[quote author=galigannarao link=topic=236410.msg2943199#msg2943199 date=1315849374]
*7*^ *7*^ *7*^ *7*^ giffu sariga veyyala jaffa
[/quote]cheating sarigane ochidni

[gvkishore.kish]

[quote author=Antaraatma link=topic=236410.msg2943209#msg2943209 date=1315849510]
hi gopi baa... em ledu baa.. ikkada db lo  sSa_j@il .. wasup wid u.. em chesav weekend..
[/quote]

yemundi mandesukunna....anthe antha kante yem peekaledu...nuvem chesav.... H&*() H&*()

[qwerty1204]

[quote author=HS link=topic=236410.msg2943174#msg2943174 date=1315849182]
[img]http://www.desigifs.com/sites/default/files/bemmi%20%284%29.gif?1290061501[/img]
[/quote]

ediyana kottaga...kottaga think cheyyandi CITI_c$y

[Antaraatma]

[quote author=gopichand-No1 link=topic=236410.msg2943212#msg2943212 date=1315849561]
yemundi mandesukunna....anthe antha kante yem peekaledu...nuvem chesav.... H&*() H&*()
[/quote]cinemalu shikaarlu shopping..  &D_@@ &D_@@ &D_@@ &D_@@ &D_@@

[qwerty1204]

[quote author=galigannarao link=topic=236410.msg2943176#msg2943176 date=1315849195]
ade seppindi  *7*^ *7*^ *7*^ ee function raasi inkekkadayina single line la vaduko @3$% @3$% @3$%
[/quote]

Declare @Text Varchar(100),@delimiter NVARCHAR(5)
Set @Text = 'can you split this?'
set @delimiter = ' '
Declare @textXml Xml
Select @TextXml = Cast('<d>' + Replace(@Text, @Delimiter,'</d><d>') + '</d>' As Xml );
SELECT T.split.value('.', 'nvarchar(max)') AS data
FROM @textXML.nodes('/d') T (split)


#~` #~`

[galigannarao]

[quote author=arey ooo samba link=topic=236410.msg2943230#msg2943230 date=1315849845]
Declare @Text Varchar(100),@delimiter NVARCHAR(5)
Set @Text = 'can you split this?'
set @delimiter = ' '
Declare @textXml Xml
Select @TextXml = Cast('<d>' + Replace(@Text, @Delimiter,'</d><d>') + '</d>' As Xml );
SELECT T.split.value('.', 'nvarchar(max)') AS data
FROM @textXML.nodes('/d') T (split)


#~` #~`
[/quote]really helpful mastaru you rock you rock you rock you rock


ayina kooda denni kooda manam functionlo pettukoni use chesukovali CITI_c$y CITI_c$y CITI_c$y

[qwerty1204]

[quote author=galigannarao link=topic=236410.msg2943241#msg2943241 date=1315850043]
really helpful mastaru you rock you rock you rock you rock


ayina kooda denni kooda manam functionlo pettukoni use chesukovali CITI_c$y CITI_c$y CITI_c$y
[/quote]

edo lee baaa...variety ga undi lee konchem approach ani.. sSa_j@il

HS aa ichin link ee easy anukoo &D_@@

[gvkishore.kish]

[quote author=arey ooo samba link=topic=236410.msg2943230#msg2943230 date=1315849845]
Declare @Text Varchar(100),@delimiter NVARCHAR(5)
Set @Text = 'can you split this?'
set @delimiter = ' '
Declare @textXml Xml
Select @TextXml = Cast('<d>' + Replace(@Text, @Delimiter,'</d><d>') + '</d>' As Xml );
SELECT T.split.value('.', 'nvarchar(max)') AS data
FROM @textXML.nodes('/d') T (split)


#~` #~`
[/quote]

asalu deenni yelaa run chestaru baaaaaaaaaaa s%H# s%H#

[galigannarao]

[quote author=gopichand-No1 link=topic=236410.msg2943288#msg2943288 date=1315850501]
asalu deenni yelaa run chestaru baaaaaaaaaaa s%H# s%H#
[/quote]sql serverlo new query open chesi run deeni akkada copy chesi run chey ante out put vachestadi

[qwerty1204]

[quote author=galigannarao link=topic=236410.msg2943298#msg2943298 date=1315850580]
sql serverlo new query open chesi run deeni akkada copy chesi run chey ante out put vachestadi
[/quote]

bhayaa nuvvu .net loo enni years ga chestunnav :0012391: