Query must filter out records beginning with "192"

  • Thread starter Thread starter Rene Wennekes
  • Start date Start date
R

Rene Wennekes

SELECT webstats.Tijd, webstats.Computer
FROM webstats
WHERE (((webstats.Computer)<>"192.168.0.204"));


if i put * after 192 i get a syntax error.
with left and ;3 also.

I want to filter out what begins with192

How do i do that?

Rene
 
.... WHERE (((webstats.Computer) Not Like "192*"));

The * is the wildcard designator. To use this, you need the Like keyword.
You can also, for example, exclude IP numbers which contain 192 anywhere in
the string by using Not Like "*192*". [Note: I'm not suggesting you do
this - it wouldn't be sensible here!]

Rob
 
Back
Top