G Guest Nov 11, 2004 #1 I just want to find records where a certain field contains more than 100 characters. How do I write this criteria out?
I just want to find records where a certain field contains more than 100 characters. How do I write this criteria out?
R RobFMS Nov 11, 2004 #2 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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
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 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
