filtering string length

**fishhead** · 08-27-2020, 08:09 AM

How can i filter a field that only has a string length of 5? Some of the records have a string length of 8 and i don't want these in my query results?

thanks in advance! : )

**isladogs** · 08-27-2020, 08:12 AM

Add a filter clause Len([FieldName])=5

filtering string length

Thread Tools

filtering string length

Similar Threads

Checking if a character in a string exists at the end of a variable length string and replacing.

cannot be a zero-length string

Field Cannot Be A Zero Length String Error

Inverted Left function - how to exclude string with variable length

I can't get the DIR function to return anything other than a zero length string

Posting Permissions