Problem getting data using Like Operator

Question

0.00/5 (No votes)

See more:

Hi,
I am trying to get data from my Access database using like operator. For example my ProducID contains NoteBook, Notes etc. Using like operator, I want to get them all shown if user types No etc.
Like operator did not give any errors but it only shows record when I put full NoteBook (does not show for Notes offcourse)

Please note I want to use the query in dataset.

Please advise how to fix it.
Thanks

Posted 25-Nov-11 5:08am

Furqan Sehgal

Add a Solution

Comments

[no name] 25-Nov-11 11:21am

How are you forming the query?

Chris Meech 25-Nov-11 11:23am

Could you please add some code snippet. Especially some lines that show how the SQL is put together. Thanks.

Furqan Sehgal 25-Nov-11 11:32am

Please check the link, I have put pic. there
http://stackoverflow.com/questions/8271659/how-to-get-data-using-like-operator

4 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)

Eduard Lu · Answer 1 · 2011-11-25T14:12:00

Solution 3

Im not sure with Access, but I do it in SQL Server like this:

SELECT * FROM [TABLENAME] WHERE No = '%' + @No + '%'

Best regards,
Eduard

Posted 25-Nov-11 14:12pm

Eduard Lu

Derek Henderson · Answer 2 · 2011-11-25T05:21:00

Solution 1

This may be obvious but did you put in the "*" ... LIKE "Note*"

Posted 25-Nov-11 5:21am

Derek Henderson

Not Active · Answer 3 · 2011-11-25T05:23:00

Solution 2

You didn't show the query you were using so this is just a guess, but make sure it is like this

select ... from table where column LIKE 'Note%'

The % is a wildcard and will find anything that begins with the characters 'Note' so it will match Notebook and Notes

Posted 25-Nov-11 5:23am

Not Active

Comments

Furqan Sehgal 25-Nov-11 11:38am

So I put it like where column LIKE '?%'
This did not return any data, I have made sure NoteBooks and Notes is there in my database.

Ashok19r91d · Answer 4 · 2011-11-26T02:55:00

Solution 4

I Found that Only few SQL Queries are working properly in MS Access...
Some Query Give Wrong Results, Throws Expectations, So It's Advised to Create Query in Access Database and Call that by Using ODBC or OLEDB Command...

Posted 26-Nov-11 2:55am

Ashok19r91d