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

2819
4
Jump to solution
09-27-2014 04:36 PM
Nathan_Molony-Benjamin
New Contributor

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.

0 Kudos
1 Solution

Accepted Solutions
MahtabAlam1
Occasional Contributor

Please try

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

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

HTH

View solution in original post

4 Replies
DanPatterson_Retired
MVP Emeritus

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
New Contributor

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?

0 Kudos
MahtabAlam1
Occasional Contributor

Please try

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

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

HTH

Nathan_Molony-Benjamin
New Contributor

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

0 Kudos