Can you use LEN in SelectLayerByAttribute_managment in Arcpy?

Question

I am trying to use LEN to select all strings in a Column that are a length of a phone number, and am unable to enter the correct expression, is it possible to use LEN in SelectLayerByAttribute_management ?

arcpy.SelectLayerByAttribute_management("Contacts_tbl", "NEW_SELECTION", "LEN(Contact_Phone_Work) = 12")

Answer 1

Yes, you're looking for CHAR_LENGTH

CHAR_LENGTH(string_exp)

Returns the length in characters of the string expression.

arcpy.SelectLayerByAttribute_management("Contacts_tbl",
                                        "NEW_SELECTION",
                                        "CHAR_LENGTH(Contact_Phone_Work) = 12")