Selecting from a table based on field length?

[Centrican]

I want to pull out all the entries on a table where a specific field is over 200 characters. I'm sure there must be a really simple way to do this that I'm just not thinking of, anyone got any ideas?

 

[giacomo]

select * from someTable where len([someField]) = 200;

hth,
Giacomo

 

[Centrican]

I was just about to come back and post that myself as I'd worked it out. Thanks, giacomo! Of course I would actually use:

"select from someTable where len([someField]) > 200"

as I wanted the fields with more than 100 characters.

 

[Centrican]

I was just about to come back and post that myself as I'd worked it out. Thanks, giacomo! Of course I would actually use:

"select from someTable where len([someField]) > 200"

as I wanted the fields with more than 200 characters.

 

[giacomo]

oops.