Thread: return record if 5th character is a letter
View Single Post
  #2  
Old May 17th, 2010, 10:02 PM posted to microsoft.public.access.queries
Douglas J. Steele[_3_]
external usenet poster
  
Posts: 3,143
Default return record if 5th character is a letter
UCase(Mid(MyString, 5, 1) = "A" AND UCase(Mid(MyString, 5, 1) = "Z"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Ron5440" wrote in message
news
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)
--
Thanks,
Ron