AnsweredAssumed Answered

ArcPy SelectLayerByAttribute_management with a domain

Question asked by on Apr 30, 2020
Latest reply on Apr 30, 2020 by jborgion



I want to subset my database and when I tried 

arcpy.SelectLayerByAttribute_management ("OHlyr3", "NEW_SELECTION", " [SUBTYPECD]" LIKE \'%Overhead\' ) 

I was getting an error on the sql expression. Than I found out the field "SUBTYPECD" is really a domain. 


What I need is to query against part of it's value like Overhead where I have "Single Phase Overhead" as a domain value  It's coded number is 2 if that's easy. 


Any ideas?