return record if 5th character is a letter
Like "????[a-z]*"
or
Mid(SomeField,5,1) Like "[a-z]"
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
Ron5440 wrote:
Hi,
I have the mid statement to pull the 5th character, but I need the
(query) syntax to filter out the ones that are a letter (alpha)
|