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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-14 : 10:57:16
|
Gero writes "I think I've now researched your site (I am here for the first time and I'm very impressed, btw.) enough to qualify for a question... ;)
Here is our problem:
We are creating a search that includes (among several other fields) four VARCHAR(100) fields that can contain CSV lists of items (ids, names, etc.) and wildcards. This may look something like this:
A user may type in "TheIDField": [5.7, 4.6, 6.*, 7.5* ]
What we're now trying to do is to...
SELECT FROM WHERE id IN ()
But at the *same* time we have to parse for the "LIKE '6.%' OR LIKE '7.5%'.
Any ideas? Help is greatly appreciated!!
G & Co.
ENVIRONMENT:
SQL Server 7.0 / NT 4.0 SP3" |
|
|
|
|
|
LIKE and IN in same query