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 - 2000-11-09 : 09:43:57
|
Kenneth writes "Hi,
This is a tough one I think - what im trying to do
is create a query that returns data from a table,
but I would like to restrict the data using another
table of values that is NOT to be included AND using
the LIKE operator
This is for a web server log file analyser using MS Access 2k.
Let's say I have a table of IP addresses, some of these
addresses is my own or from other people in my company and
these should be filtered out.
I have created a table called: FILTER_IP
This table will hold the IP addresses that I do
not want in the output from the query.
This way I can enter new IP addresses to be filtered
out on the fly without having to hardcode it into the
query.
To complicate this query further, I would also like
to be able to use the LIKE operator in this query so
I could enter something like:
*122.45.33*
*122.45.34*
...
...
Into the filter table, this would make it easier
to filter out a range of IP's instead of entering
each one since most of the IP's is dynamic and
changes each time a user dial's in.
I know it is possible because I have done it
before - but I cant remember how I did it :(
Thanks in advance!" |
|
|
|
|
|
Using IN(TABLENAME) with LIKE