Character Query

[KIMA06]

I have a file that I need to query that has names of cities in a particular
field. I need to find all cities that have more than 4 characters in its
name. Thanks in advance.

 

[Brendan Reynolds]

I have a file that I need to query that has names of cities in a particular
field. I need to find all cities that have more than 4 characters in its
name. Thanks in advance.

WHERE Len([NameOfField]) > 4

If the value may be null, you might need to modify that to something like
.....

WHERE Len([NameOfField] & "") > 4

 

[Jerry Whittle]

SELECT YourTable.*
FROM YourTable
WHERE Len([City_Field]) >4;

 

[Jerry Whittle]

SELECT YourTable.*
FROM YourTable
WHERE Len([City_Field]) >4;

 

[Jerry Whittle]

SELECT YourTable.*
FROM YourTable
WHERE Len([City_Field]) >4;

 

[Jerry Whittle]

SELECT YourTable.*
FROM YourTable
WHERE Len([City_Field]) >4;

 

[Jerry Whittle]

SELECT YourTable.*
FROM YourTable
WHERE Len([City_Field]) >4;

 

[Jerry Whittle]

SELECT YourTable.*
FROM YourTable
WHERE Len([City_Field]) >4;

 

[KIMA06]

Thanks for the answer. It worked.