[RESOLVED] using Like in sql statement in C#

[sunshine123]

Hi,

Im passing a sql query using Like. It works fine when I run in Access.

But when I try to run it thru C# it does not retrieve any data into the datatable. So its something to do on the c# end and not the database.

this is my code:

string strSql = "Select * from tablename where timefield Like '* + s2 + "*'";

timefield is of datetime datatype.
s2 is a string value that has something like 9:45.

What could be the problem??