When I had the entire selection in one line of code
arcpy.SelectLayerByAttribute_management("wtlnd4Analysis", "NEW_SELECTION", ' "WETLAND_TYPE" = \'RIVERINE\' AND "ATTRIBUTE" LIKE \'%H%\' OR "WETLAND_TYPE" = \'LAKE\' AND "ATTRIBUTE" LIKE \'%UBH%\' ')
I loaded this into the python window and I never saw the selection change. It would be obvious, because there are several very large river that would be removed. I tried adding () around where clause and still nothing changed.Today I run this on on my desktop at work instead of my laptop and it doesnt even work as I step through. I get an empty selection no mater what? Im stumped.ThanksAliciaBack working on laptop, and this works thus far:
arcpy.MakeFeatureLayer_management(wtlndPath, "wtlnd4Anlys_lyr")
arcpy.SelectLayerByAttribute_management("wtlnd4Anlys_lyr", "NEW_SELECTION", ' "ATTRIBUTE" LIKE \'R%H%\' OR "ATTRIBUTE" LIKE \'L%UBH%\' ')
arcpy.SelectLayerByAttribute_management("wtlnd4Anlys_lyr", "SWITCH_SELECTION")