Note this is a Feature Class in n SDE SQL db
# DEFINE THE COUNTIES FC
arcpy.MakeFeatureLayer_management(r"E:/Projects/County/xxxx.sde/Counties", "counties_lyr")
results = arcpy.SelectLayerByLocation_management("counties_lyr",
"NEW_SELECTION",
"[FURST_JURI]='ACCOMACK'")
Ive tried this for Text field
"[FURST_JURI]='ACCOMACK' "
"FIRST_JURI = 'ACCOMACK' "
' "FIRST_JURI" = 'ACCOMACK' "
Ive tried for Int
"FIPS2 > 1"
' "FIPS2" > 1'
"[FIPS2] > 1"
I know the attributes and values exist