>>
>>BTW, did you try in MySQL directly
>>
>>

select * from MyTable where myField like '%t%'

?
>
>Yes, of course. And of course it works.
>
>The problem is that MySql seems to be getting

>select * from myTable where myField LIKE '% '+ 't' + '%')' at line 1

Ok, I understood it and already suggested a workaround. Use select * from myTable where myField like ? and set your parameter in the Selecting event.