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.