multiple definitions on a Feature Layer filter

[SangamLama]

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

[DominiqueBroux]

Try "500000< POP2000 AND POP2000 < 1000000"

[TerryGiles]

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

[SangamLama]

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