query to select punctuation marks

  • Thread starter Thread starter fishberry
  • Start date Start date
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.
 
Try,

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

Regards,

ET Sherman
 
Back
Top