multiple definitions on a Feature Layer filter

Question

Howdy,

I'm wondering if I can do something like "500000> POP2000 > 1000000" instead of  "POP2000 > 1000000" for a filter? Basically, trying to get only certain set of features back with both upper and lower limit. A good use case would be to find out which parcels are between area 500 sq feet to 1000 sq feet.

thanks

SangamLama · Answer

thanks to you both. Look at the Where property of a FeatureLayer.  Documentation says 'Any legal SQL where clause operating on the fields in the layer is allowed' so you should be able to do something like
  FeatLayer.Where = "POP2000 > 500000 AND POP2000 < 1000000";

What's considered legal SQL statement will depend on the underlying data source.

TG

TerryGiles · Answer

Look at the Where property of a FeatureLayer.  Documentation says 'Any legal SQL where clause operating on the fields in the layer is allowed' so you should be able to do something like
  FeatLayer.Where = "POP2000 > 500000 AND POP2000 < 1000000";

What's considered legal SQL statement will depend on the underlying data source.

TG

DominiqueBroux · Answer

Try "500000< POP2000 AND POP2000 < 1000000"