Thread: return record if 5th character is a letter
View Single Post
  #4  
Old May 17th, 2010, 10:27 PM posted to microsoft.public.access.queries
John Spencer
external usenet poster
  
Posts: 7,815
Default 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)