Access Query Question?

Question

I have a database where i would like to query out all of the entries that have a space and character (alphabetical) and another space,

Example

Jill M Jones

I am just using a simple access query,

Wanting to know what to place in the "criteria" of the sort.

I've found that in access the wildcard for any alphabetical character is ?...however

"space ? space" just doesnt seem to work

Indeed, i was missing the idea that i have things in front of and behind the spaces...so "* ? *" worked perfect, THANKS!

Answer 1

I don't know if this will work. If I remember the wild cards correctly you need to use something like "* ? *" (or basically { match anything wildcard }{ space }{ match 1 wildcard }{ space }{ match anything wildcard }

Answer 2

what scripting are you usign

if it's php you can use php eregi (or simialr) to show results without "space *letter* space"

Answer 3

In oracle it's
'%_%_%', where underscore is actually the space.