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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-05-02 : 02:03:31
|
| Dear Experts,I've a table my_table, and in that table, I've a column my_column.the data in that column is like this.........100+L1VAT+L2VAT+123+12+L1TCS+L1VAT+12+L2CST+300+100+BTCS+BVAT+L2TCS+L2VAT+BVAT+BCST+L1CST+300+Now I'm trying to extract the data between + symbols. suppose"L2TCS+L2VAT+ " for this type of data, I need the output L2TCS,L2VAT I'm not replaceing + with a , (comma) but i need the data between the + symbols.how can i write afunction for this? I'm trying with substring function. but I was unable to get the logic to reach +.please help me in this regard.thank you very muchVinod |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-02 : 02:09:50
|
| Check this: [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648[/url] on discussion about best split functions.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-05-02 : 04:10:25
|
| That is a great function (dbo.split) and my perpose is served. thank you harsh for the linkVinod |
|
|
|
|
|
|
Function help