Thanks guys...all answers worked.
--
Thanks,
Ron


"John W. Vinson" wrote:

On Mon, 17 May 2010 12:36:01 -0700, 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)

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.
--

John W. Vinson [MVP]
.