return record if 5th character is a letter

  • Thread starter Thread starter Ron5440
  • Start date Start date
R

Ron5440

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)
 
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)
Click to expand...

You don't actually need a MID at all: a criteron of

LIKE "????[a-z]*"

on the text field itself will work.

If you do use Mid, you can use

LIKE "[a-z]"

as a criterion on the extracted single character.
 
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
 
Thanks guys...all answers worked.
--
Thanks,
Ron


John W. Vinson said:
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)
Click to expand...

You don't actually need a MID at all: a criteron of

LIKE "????[a-z]*"

on the text field itself will work.

If you do use Mid, you can use

LIKE "[a-z]"

as a criterion on the extracted single character.
Click to expand...
 
Back
Top