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.
| Author |
Topic |
|
iloveorangesoda
Starting Member
30 Posts |
 Posted - 2008-02-26 : 09:46:54
|
| I have a table that holds a list of exceptions in one field i.e. Message. This field might look like this: One Rejected, Two Rejected, Three Rejects, etc... What I want to do is split this string by comma so that I can output the string on different rows in a front end application.e.gOne RejectedTwo RejectedThree RejectedCan anyone advise how I would do this?My current sproc for getting information out looks like thisSELECT Id, Type AS [Type], Number, Message, DateActioned, ActionedByFROM t_ExceptionWHERE DateActioned IS NULL ORDER BY Number ASC |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-02-26 : 11:03:36
|
| Alternatively if you want to show data in front end application, use split function thereMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Split String