Results with 100 characters or less

[clocola]

Hi

I am writing aSQL query in Access. I want to return results in a text field which are 100 characters long or less.

Thanks

[Stewart Ross]

Hi Clocola. We can't answer your question as you have not provided us with information about what you really want to do. Please help us to help you by asking your question in line with our posting guidelines at the top of the page.

-Stewart

[NeoPa]

If you want to select only those records where a particular field contains entries which don't exceed 100 characters then :

SELECT ...
       [TextField],
       ...
FROM   [YourTable]
WHERE  Len([TextField])<=100

NB. Don't ignore Stewart's point. Just because it is possible to provide help when a question is written poorly, doesn't mean we appreciate your not making any effort to present your question properly.