All records Where [table x].[field x] contains > 100 characters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I just want to write out a query that returns all records (from a single
table)where a particular field contains more than 100 characters. Can
someone please tell me how to properly write out this criteria?

Thanks much in advance.
 
I just want to write out a query that returns all records (from a single
table)where a particular field contains more than 100 characters. Can
someone please tell me how to properly write out this criteria?

Thanks much in advance.
Click to expand...
Select TableName.* From TableName
Where Len([FieldName]) > 100
 
ExcessAccess said:
I just want to write out a query that returns all records (from a single
table)where a particular field contains more than 100 characters. Can
someone please tell me how to properly write out this criteria?
Click to expand...


Len(thefield) > 100
 
Back
Top