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 |
|
BUser
Starting Member
11 Posts |
 Posted - 2010-10-06 : 19:18:43
|
| Hello !Table A has the following columnsID & Description.Now, ID & Description can have the following values -ID Description11 Cotton232 Cotton Wool2322 Corn6566 Corn huskNow, how do I find out all the columns that have the similar data like above. What you might have observed here is this that, for 11 & 232, they BOTH have COTTON in their description. Now, how do I write my query.Thanks,Don. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BUser
Starting Member
11 Posts |
Posted - 2010-10-06 : 19:20:32
|
| TKizer, thank you for the quick reply. No, I dont know how to do that... I was thinking more like substring, instring...on those lines & cant seem to get it ... Please advise ! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BUser
Starting Member
11 Posts |
Posted - 2010-10-06 : 19:29:34
|
| TKizer, thank you for the reply. Yes, I will use contain and got answer. Can you please also post answer for my previous question. that is different thred. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Inside the string