records where characters in [field x] > 100 ??

[ExcessAccess]

I just want to find records where a certain field contains more than 100
characters. How do I write this criteria out?

 

[RobFMS]

Select <field>
From <table>
Where Len(<field>) > 100

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-