Query specific length

[smpayne69]

I have a query in which I need to pull all values from a field that is exactly 10 characters in length (Alpha or Numeric). Can anyone help me with this?

Thank you!

 

[kaveman]

Create a new field on your query to calculate the length:

Length:Len([field])

then set your criteria to only return records where this field is 10

 

[antomack]

You need to use the Len function in the query as below

SELECT * FROM YourTableName
WHERE Len(YourFieldName) = 10;

 

[smpayne69]

Great!

Thanks so much for you help!