I tried to find the equivalent of Left fuction because it doesn't work in ArcGis. I found a post that suggested the word substring:
the query is:
and I tried:
"('IAS.C_A')<>substring(['C_A1' from 1 for 5])"
in the function:
arcpy.Select_analysis(in_features=TW,out_feature_class='ac', where_clause= "('IAS.C_A')<>substring(['C_A1' from 1 for 5]))";
but shows error in syntax.
"'IAS.C_A'<>'substring(C_A1, 1 ,5'")
For each part we add a single quote and a double one in the start and one in the end of the where clause.