I'm working on a database, that features a list of City´s. What I have set up is 3 search fields, City, State and Zipcode.
Now i want to search for the Zipcode from the first position on (for a explicit area).

so, when i search for:
76
results are:
76123
76145
76245...

and for 761
results:
76133
76145

and not:
13376
13763
76133

Any Ideas on how I can do this?
Many thanks for your help.

[This message has been edited by Rico (edited January 28, 2000).]