I am stuck on syntax of an sql statement inside CalculateField_management and I can't seem to get the sql expression syntax correct. I can run the select analysis in arcgis and it works but I can't seem to get it to run.
arcpy.CalculateField_management("indata", "field",'!FIELDNAME![2:4]' ,"PYTHON") works fine.
But when I try to do arcpy.CalculateField_management("indata", "field", '!FIELDNAME! = "Value"',"PYTHON")
I get a syntax error on the expression. I've tried multiple options including the three double quotes and various combinations of single and double quotes.

Any ideas?

just a guess:

I figured it out last night in some late night python epiphany.

arcpy.CalculateField_management("indata", "field", "!FIELDNAME! == \"Value\"","PYTHON")

it was the double equals that threw me off, I had already tried "!FIELDNAME! = \"Value\"".