Query number of characters in a field

[RitchieJHicks]

I wish to query my data and for the result to be that the query shows all
records where the data within the queried field is more than seven characters
long.

Is this possible what type of query do I use?

 

[fredg]

I wish to query my data and for the result to be that the query shows all
records where the data within the queried field is more than seven characters
long.

Is this possible what type of query do I use?

Select TableName.* from TableName
Where Len(TableName.FieldName) >7

 

[John Spencer]

OR use criteria like the following against the field

LIKE "????????*"

This one is straight SQL and does not call the VBA Len function so it is
possible that it may be faster than using the Len function.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================