Find Length

[whitestone]

Hello All,

This is probably really easy.

I have a table containing a column of bank account numbers that I need to clean. Firstly I want to pick out all of the numbers that are less than eight characters...how do I do this in query. I thought I could just sort the table by that column and they would appear first but this is not the case as some numbers begin with 0 etc.


Thanks

Ben

 

[PaddyIrishMan]

You need to specify "Len" in the query criteria.
i.e. Len([YourFieldName])<"8"

Regards,
Patrick

 

[Pat Hartman]

8 is numeric and therefore should NOT be surrounded by quotes.

Len([YourFieldName])< 8