Hey all,
I'm trying to create a definition query for a points layer where I only was to display the points in the TYPE field of 1 and 2 and then leave type 3 hidden. Anyone know how to do this?
The Syntax does depend on the input data type. Assuming it's a feature class, use https://pro.arcgis.com/en/pro-app/latest/help/mapping/navigation/write-a-query-in-the-query-builder.... as an example.
For the interactive selection:
Type is equal to 1
OR
Type is equal to 2
for SQL syntax:
TYPE = 1 Or TYPE = 2
NB if the numbers are actually strings(text) then enclose '1' and '2' in quotes.
Got it! Thanks!
TYPE IN (1, 2)