The use of <> whilst setting up a definition query

[PatrickMurphy1]

Over the last couple of years I've been using the <> in query builder to exclude out certain categories, unfortunately this year it doesn't seem to be working anymore.

I am using the same data, the same version of ArcMap (10.0 Service Pack 5).

Would be any obvious reason for this

Paddy 

[PatrickMurphy1 · Accepted solution]

Hi to All

It has finally worked out for me

I just replaced the "OR" with "AND" and it worked

Thanks all

Appreciate it

Regards

Paddy

[RyanStovern__GISP]

Sweet. Glad you got it figured out. It is amazing how a little word can change so much.

[ChrisCameron]

Here is a tip for doing basically the same thing, but especially useful when you have a longer set/list of values that you are using to exclude records:

STATUS NOT IN ('COMPLETED','EXPIRED')