Query number of characters in a field

[RitchieJHicks]

I wish to run a query within my database where the query result is a list of
all records where the data in a particular field is more than 7 characters
long.

Can anyone advise on how I would do this please?

 

[Allen Browne]

SELECT *
FROM Table1
WHERE Len([SomeField]) > 7;

 

[Dale Fye]

This will cause an error if [SomeField] is NULL, so try:

SELECT *
FROM Table1
WHERE Len([SomeField] & "") >7;

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

SELECT *
FROM Table1
WHERE Len([SomeField]) > 7;

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I wish to run a query within my database where the query result is a list
of
all records where the data in a particular field is more than 7 characters
long.

Can anyone advise on how I would do this please?