Counting characters

[Freckles]

I need to run a query that tells me if a field has less than 10 characters. Any ideas?

: Deb Koplen
deb.koplen@verizon.com
koplend@swbell.net (weekends and nights)

A person can stand almost anything except a succession of ordinary days.

 

[SgtJarrow]

try something like

SELECT Table1.Field1, Len([Field1]) AS Expr1
FROM Table1
WHERE (((Len([Field1]))<10));

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[PHV]

If you care the Null case:
WHERE ...
AND Len(Trim(Nz([name of field], ""))) < 10
...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244