Incremental search with numbers

Tech-Archive recommends: Speed Up your PC by fixing your registry


I have implemented an incremental search uses the LIKE operator in a query to
select aphabetic data from an alphabetic fields in a table based on
characters keyed in on my form. This works fine. The problem comes when I key
in numeric data on my screen and try to use the LIKE operator against a
number field in my table. I understand what's happening, but I don't know
what to do about it. It seems that I need to be able to compare the keyed
characters (left to right) against the same characters in my table, or
something like that. Does anyone have any ideas as to how to accomplish this?

Thanks...
.