"select * from book where name like '*x*' OR description like '*x*';"
replace your query with the following
"select * from book where name like '%x%' OR description like '%x%';"

Hi there,
I have the same problem, is there any solution to that. I tried both * and % but nothing changed. it does not return any record.

Regards

Hello.
I ran into the same problem today. Fortunatelly for me , I found the solution.
My old code:
I tried with both % and *. Nothing worked. I searched google, but didn't found answear. Then I tried:
Adding % sepparately, as a char, does the trick. (depending on the access file version, you may need to use * instead of % - the former works on Access 2003 file format).

I hope this helps.
P.S. Sorry for the bad english, it is not my native language.

Thank You All
I Had The same problem then when i replaced * with % every thing became right

Here is Some Code :

SQLStatement = SQLStatement + " and StudentName like '%" + textBox26.Text + "%'";
OleDbCommand command = new OleDbCommand(SQLStatement, gConnection);
gDataAdapter.SelectCommand = command;
gDataTable.Clear();
OleDbCommandBuilder gCommandBuilder = new OleDbCommandBuilder(gDataAdapter);
gDataAdapter.Fill(gDataTable);
dataGridView1.DataSource = gDataTable;

Sorry for the bad english, it is not my native language.
my language is Arabic.
I Like Arabic verymuch.

Hello.

I'm having a similar problem. My LIKE sql statements are not retrieving the correct records. The difference, in my case, is that it is returning records, only incorrect records. Let's say the query should return 3 records. Instead of returning 3 different records, it returns the first record 3 times.

If I use *'s, I get no records, which makes be believe the correct wild card card is %. And it's using % that is causing the error described in the first paragraph.

I have already tried to append % surrounded by single quote, double quotes, in the same line as the rest of the string, and in a separate line. Every time I get the same result.

Does anybody have a clue? Any help will be much appreciated.

Thanks a lot in advance

Try '%x%' - Access uses * but pure sql uses % in LIKE statements

JMu was right, i tried his way and fixed the problem.
Thank you JMU