using like in access 2003 queries

Question

0.00/5 (No votes)

See more:

Hi all,

I have a table in access 2003 and I want to use like statement in it but I can't.
My query is like this:

Select * from Mytbl where title like '*news *'

and I also use this:

Select * from Mytbl where title like '%news%'

none of them work.
I mean they don't return any row.

Posted 13-Dec-10 19:30pm

davmszd

Updated 13-Dec-10 19:32pm

JF2015

v2

Add a Solution

Comments

JF2015 14-Dec-10 1:33am

Edited for code formatting and spelling.

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)

Toniyo Jackson · Answer 1 · 2010-12-13T19:38:00

Solution 1

Try this,

Select * from Mytbl where title like '*news'

or

Select * from Mytbl where title like 'news*'

or

Select * from Mytbl where title like '*news*'

Posted 13-Dec-10 19:38pm

Toniyo Jackson

Updated 13-Dec-10 19:59pm

v3

Comments

Toniyo Jackson 14-Dec-10 1:54am

I dont know, what is your problem. Actually this is the correct answer.

davmszd 14-Dec-10 2:14am

thanks toni

davmszd · Answer 2 · 2010-12-13T19:49:00

Solution 2

dear ToniyoJackson
i should mention that at first i m using that in access not in vb .net code it does not any row
i try your suggestion but again it does not return any row

Posted 13-Dec-10 19:49pm

davmszd

Comments

Toniyo Jackson 14-Dec-10 1:51am

Don't write your comments here. You have add comment button below all answers. so write your comments below the appropriate answer

Toniyo Jackson 14-Dec-10 1:52am

Do u have any data in table with title as news?

davmszd 14-Dec-10 1:53am

i do have data in my table

Toniyo Jackson 14-Dec-10 1:58am

First u read this article and learn how and where to give *.
http://www.ehow.com/how_4547073_microsoft-access-using-like-operator.html

davmszd 14-Dec-10 2:01am

i have read them all
and i also use like in sql transaction
but in access 2003 i got into problem

davmszd 14-Dec-10 2:02am

at first i take look to this article and try to follow the tutorial
but ...................
http://articles.techrepublic.com.com/5100-10878_11-6154704.html