filtering text fields by the amount of characters

[ahyland]

I need to filter out any records where the characters are not equal to characters. If I use "*****" that gives me all the 2, 3, and 4 character records too. How do I filter those out?

[Brilstern]

ahyland,

Not really sure what you are asking here. Can you elaborate? providing some of your code and table structure would be handy.

[twinnyfo]

ahyland,

Do you mean you want all records that have values that are not within ASCII Characters 65-90 and 97-122 (the ASCII set of letters) or something else.

Your question is a bit unclear, as Mr. Bias has noted, and I'm not sure what you mean by 2, 3, and 4 character records. Either way, the only method I can think of doing this is to search each record (just one field or all fields???) individually, then look at each character individually for "non-characters" (again the verbiage is a bit unclear what you mean, because characters are always characters.....) and identify those records. With many records, fields, large strings, this could take a long time, but just about anything can be done.

Please provide an example of what you are looking for.

[twinnyfo]

I just re-read the title of this post. Are you looking to exclude records that do not have a certain length (i.e. a number of characters)?

A simple method would be:

WHERE Len([FieldName]) <> 3