Query field for number of Characters

[muppetmad]

I need to query a field for any records where this field has less that 10 characters. Any suggestions? The reason is depending on the type of customer the field can be 10 or 11 digits. IF there are less than 10 but not blank they need to be pulled for correction.

 

[pbaldy]

A query with this WHERE clause:

WHERE Len(FieldName) < 10