Query number of characters in a field

  • Thread starter Thread starter RitchieJHicks
  • Start date Start date
R

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?
 
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?
Click to expand...

Select TableName.* from TableName
Where Len(TableName.FieldName) >7
 
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
'====================================================
 
Back
Top