Query problem, shortening a query can anyone help?

S

Sacred

I'm trying to make a query system and want to speed up the way it is used.

Basically I might be wanting a query on a street name. The street name is:

Cherry Tree Drive

I set up the query as normal and have it so I need to type in a street name
before it can find anything. The problem is this can be time consuming and is
relient on 100% correct spelling.
I want it so I can type say

Cher

and it would find

Cherry Tree Drive (and anyother with them matching letters)

I'm not sure how to do this exactly so thought someone here might be able to
help.

Thanks,
Sacred
 
Top