Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Search String to table

Author  Topic 

keyursoni85
Posting Yak Master

233 Posts

Posted - 2010-06-29 : 09:46:01
Hi,
I have a values like..
"XXX==4||LDL==testtest||PSP==S/e"

Seperator is fix == and ||

Now i need above string to table like
first second
XXX 4
LDL testtest
PSP S/e

plz help

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-06-29 : 10:05:27
Search for split function here

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

keyursoni85
Posting Yak Master

233 Posts

Posted - 2010-06-29 : 10:18:19
Thanks,
can i have some example please ?
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-06-30 : 02:48:00
Refer this
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

keyursoni85
Posting Yak Master

233 Posts

Posted - 2010-06-30 : 03:03:42
Thanks to you
Go to Top of Page
   

- Advertisement -