query to select punctuation marks

F

fishberry

I have a table(sentences) which has two columns:
Indexnumber,Sentence.Sentence column contains a lot of English sentences. I
want to select all sentences which contain question mark.
I use sql:
select *
from sentences
where sentence Like "%?%"
But it doesn't work.
 
E

ET Sherman

Try,

SELECT Sentences.*
FROM Sentences
WHERE (((Sentences.Sentence) Like "*?*"));

Regards,

ET Sherman
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top