SQL Query in labeling

[ELTerrell]

Hi all,

I have 10 cities within a county and I'm trying to label 9 of them.  I thought an SQL query in the label feature would eliminate the one I didn't want labeled.  I thought it should look something like this "Name" = 'New York' AND 'Los Angeles' and just leave out the one I don't want?

[ELTerrell]

So I found a solution although it wasn't the one I anticipated.  I "added label classes from symbology categories" after having deleted the one city from symbology.

However, I'm thinking there has to be a way to label those using SQL query.

[MichaelVolz]

How about OR instead of AND?

[ELTerrell]

I tried that, I still get an error message.  I also tried IS.  I can only think that maybe it has something to do with the quotations?

[MichaelVolz · Accepted solution]

Does ArcGIS Explorer Desktop have classes for labels like ArcMap does?  If so, you can add a SQL Query there, that should allow either the syntax:

"Name" = 'New York' OR "Name" = 'Los Angeles'

or

"Name" in ('New York', 'Los Angeles')

[ELTerrell]

That worked...I just needed the second 'Name' instead of Name = New York OR Los Angeles.

[BenVan_Kesteren1]

"Name" in ('New York', 'Los Angeles')

This is the SQL I use often as sometimes the list can get quite long, and writing "Name" = XXX OR  "Name" = XXX OR... over and over gets tedious 😄

[ELTerrell]

Thanks Ben!  I'll try that next.

[EllenBryson2]

Michael made a great suggestion with the IN function.

If you're wondering how to fix your original query, here's the solution.

"Name" = 'New York' OR "Name" = 'Los Angeles'

You need to mention the field name twice. And in this context I think the OR is what you want.