phone number of area code

[yanliang]

I ran into a problem where I need to find those who did not enter an area code for phone numbers.
(626)421-3459 is correct
but some are ()421-2459, are the one I need to find.
how to find those who those.

 

[Gasman]

Try Mid(field,2,1)=")"

 

[namliam]

Like "()%"
left(field,2) = "()"
len(field) <= 10
Just to offer a few ideas