finding the number of characters in a memo field

M

mrtwice

I would like to search all of the rows in a table for a memo fiel
called "directions" that is greater than 300 characters.

For example:

Code
-------------------
SELECT id
FROM customer
WHERE number_of_characters(customer.directions) > 300

-------------------


So, what I am looking for is whatever I would replace my imaginar
number_of_characters() function with.

Thanks for any help
 
T

Tom Ellison

Dear Mr. Twice:

The function is Len().

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Top