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 |
|
bridge
Yak Posting Veteran
93 Posts |
 Posted - 2005-08-30 : 05:15:23
|
| I want to know can we use IN within LIKE, or if there is a way please let me know. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-08-30 : 05:23:56
|
| Post a sample of your input data and the matching expected results....to advance this faster. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-08-30 : 05:43:02
|
no you can't. to use like you need to do an OR betwen desired conditions.Go with the flow & have fun! Else fight the flow  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-30 : 09:21:38
|
| You could have a list of things to match in a string - along the lines of "foo%,bar%,foo%bar" - then split them, and JOIN to the split records using LIKE. Not exactly straightforward!, but might do what you wantKristen |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-08-30 : 09:29:17
|
good one kristen... i'd use igor's functions with optional delimiter for splitting  Go with the flow & have fun! Else fight the flow |
|
|
|
|
|
|
LIKE with IN