query to select punctuation marks -- sql server odbc

Sue Hoegemeier
8/7/2003 7:51:33 AM

When you say it doesn't work, do you get an error or no
results? The following works when I tested it:
select *
from Sentences
where Sentence like '%?%'

--Sue

On Thu, 7 Aug 2003 11:02:19 +0800, "fishberry"
[quoted text, click to view]

fishberry
8/7/2003 11:02:19 AM

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.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server odbc

sql server odbc : query to select punctuation marks