I have a Sql query with a number of AND LIKE used in the query. It works just fine with maybe 3 AND LIKE in the query but when I add more it doesn't show all the matching rows in the DataGrid. It finds only one or two. I think somehow I need a delay not sure how to do that or where to put it in code. When the user clicks a command button it runs adodc = The query then I do an adodc refresh.
I'm hoping somone had this problem and hopefully a solution.

Thanks for any and all help