Hi
How about:

Select * From myTable where myField LIKE Text1.text