If a data field has five characters...

[brendanDATA]

I am trying to insert data into a new table if the record has a five character zip code. It doesn't matter what the zip is, it just has to have five characters. I have the rest of the query, I just don't know what the where would look like to say where a field has five characters in it. Anyone have ideas?

 

[Crowley16]

where Len(field) = 5

or if there are spaces you want to remove...

where len(replace(field, ' ', '')) = 5

I'm not 100% sure of the syntax for replace though...

--------------------
Procrastinate Now!

 

[genomon]

Or len(trim(field)) = 5 if there are no embedded spaces.....