Building a Search engine

I'm building a prog to extract data from a mdb file. The prog is complete but I need a better search engine. Currently I only know how to search for an exact (string) match. Q: how do you search for partial string match's? ex: I have a field in the database with the string "Cell KY - 1/2/SV" and I want the ability to enter "KY" into a text box and hit the search button to locate all matching fields with "KY". Thank you in advance for any help you may provide.

Select * from MyTable where MyField LIKE '*KY*'