how to write like oparator?

[srinivaschintala]

Hi,

I have table Transaction in that table i have field name email i want list that all emails in text box auto suggest for that i need query email like %email%.

Now can any one help me on this please i dont have any function using like oparator