C# Database Query (Access) using LIKE '*'

Question

0.00/5 (No votes)

See more:

Hi Everyone,

I'm using the database class from
http://www.codeproject.com/KB/database/csharpaccessdb.aspx
and for the most part it has worked exactly how I want, which is great.

I came across a problem when one of my queries uses the LIKE '*' condition. For some reason, whenever * is used, it doesn't work.

Let me give an example...
SELECT Title FROM Books WHERE Title LIKE 'Tomorrow, When The War Began';
WORKS in Access and C#

SELECT Title FROM Books WHERE Title LIKE 'Tomorrow*';
Works in Access, but not in C#

I can't seem to find out why the * doesn't work. I got to the stage where I was copying the query directly from a working Access query where it returns the correct results, but when I put it in C#, it just doesn't work. Every other query that doesn't involve LIKE '*' works in C# with the exact same results as Access, so there isn't a problem connecting to the database.

If there are any suggestions, that would be a great help!

Thanks,
Josh.

Posted 27-Nov-10 1:47am

Joshua Henderson

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2010-11-27T02:00:00

Solution 1

I dont what the code that builds the query looks like, but as a guess, just try using an @ before the string that contains 'Tomorrow*'.

Posted 27-Nov-10 2:00am

Abhinav S

Updated 27-Nov-10 2:01am

v2

Joshua Henderson · Answer 2 · 2010-11-27T02:21:00

Hi Abhinav,

Thanks for your prompt reply. I looked around online for some more Access and SQL in C#, and found that if I used a % instead of a * in C# it will work. In Access, you can only use * as a wildcard (I will admit, normally using SQL Server I initially used % as a wildcard to find that it didn't work.)

A little bit annoying (as I normally write the queries in Access and then copy then over, need to remember to change all the wildcards now), but at least it's working now!

Again, thanks for your prompt reply.

Josh.