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 |
|
rwsjbs
Starting Member
17 Posts |
 Posted - 2010-03-23 : 17:18:59
|
| Thank you for looking at my post.I have a field called DESCRIPTION in a table called ITEM. This Description field has commas that seperate the data. Here are a couple of examples of the data in the Description field:(Data1, Data2,Data3...,Always Color, Always Size)Example 1: Tshirt,Girls,Summer,Black,Large Example 2: Tshirt,Black,SmallThe data in the Description field is seperated by commas but the data after the last column is always the SIZE and the second to last data is always the Color. My problem is that there may be several commas in the string so I can't use a SUBSTRING to search from left to right to pull out the Size & Color.I'm trying to create a SUBSTRING that will search from Right to Left and seperate out the Size and Color data.Please let me know what you think I should try.Thank you,Richard Scott |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-23 : 17:54:57
|
reverse()
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
rwsjbs
Starting Member
17 Posts |
Posted - 2010-03-23 : 18:12:49
|
| That will work!Thank you again for your help,Richard Scott |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-23 : 18:15:24
|
welcome 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
|
|
Help with SUBSTRING