nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how do I select the 48 conterminous US states from a layer of all US states and territories?

Nathan_Molony-Benjamin

I'm supposed to query the attribute table but I'm having trouble figuring out an SQL statement that will work. I've tried countless statements and sometimes they're verified but they do not select the records. How do I use an SQL statement that will exclude all non conterminous states and territories? Please help. I need to figure out this query.

Find more posts tagged with

Accepted answers

Please try

STATE NOT IN ('AK','HI','PR','VI')

In case of syntax error change single quote to double quote.

HTH

All comments

DanPatterson_Retired

why not query for what you don't want...then switch the selection manually or by using your sql type "Not" operand

Nathan_Molony-Benjamin

What would that look like?

I tried NOT STATE = 'AK HI PR VI' and that didn't work.

I'm sure it has something to do with the way I format the statement. Could you please show me?

Zip_Code_Ordered .png

Please try

STATE NOT IN ('AK','HI','PR','VI')

In case of syntax error change single quote to double quote.

HTH

Nathan_Molony-Benjamin

Hey thanks man! I guess I have to work on my computer syntax. Much appreciated!

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.