TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
priya priya
NA
17
101.4k
Splitting commas in a string
Aug 24 2009 8:27 AM
Hi,
i want to know if i give some value like this:
select * from split('11,12|13,15|16,18')
i should get the output as
Id Value1 Value2
1 11 12
2 13 15
3 16 18
please help me ,how to do this in sql server 2005
Thanks in advance
Reply
Answers (
2
)
query to display row values in to column value
splitting commas in a string