Filter a string field by its length

[AngelaSchirck]

I have a parcels layer and a table widget in EB developers ed 1.12 (latest release).  I have 10-digit parcel numbers and 17-digit parcel numbers, but they are in the attribute table as strings.  I need to filter out all 10-digit parcel numbers, but the filter widget does not allow for writing your own SQL statement (this would be a very simple task if it would). When I use the "build sql expression" tool for parcel number my choices are:

(the last choice not see is "is not blank.")

Does anyone know a way to filter out these nearly 2800 10-digit parcel numbers without entering them one-by-one? 

ESRI: Can you PLEASE add an option to edit/type your own SQL statement in the filter widget??

[JeffreyThompson2 · Accepted solution]

Try Contains _________________

That is 17 underscore characters. Underscore is the single character wildcard in SQL.

https://www.w3schools.com/sql/sql_wildcards.asp

[AngelaSchirck]

Perfect! Thanks!