Length

[Jim]

I have a field that has text of multiple lenght. Is tyhere a sql
select command that will only select records where the text is five
letters or less?

 

[Ken Snell [MVP]]

SELECT *
FROM TableName
WHERE Len(FieldName) <= 5:

 

[John Spencer]

SELECT *
FROM Table
WHERE SomeField Not Like "??????*"

In the query design view enter the criteria under the field
Not Like "??????*"

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

 

[John Spencer]

This will return records where the field is Null.

If you need that you will need to change the criteria to
Not Like "??????*" or Is Null

SELECT *
FROM Table
WHERE SomeField Not Like "??????*"
OR SomeField is Null

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