By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,285 Members | 1,691 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,285 IT Pros & Developers. It's quick & easy.

Text string search query

P: n/a
Hi group

I have a database that contains questions and answers. I need to
create a query that will produce results for all the questions and
answers fields by looking for a single word that will be contained
anywhere in the text string.

i.e. If I wanted to list all questions and answers that contain the
word "internet" how would I do it?

Thanks in advance

Joe
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
SELECT tblTest.TestText
FROM tblTest
WHERE (((tblTest.TestText) Like "*internet*"));

Search help using the keyword 'like' for details.

--
Brendan Reynolds
<pa*********@tiscali.co.uk> wrote in message
news:t7********************************@4ax.com...
Hi group

I have a database that contains questions and answers. I need to
create a query that will produce results for all the questions and
answers fields by looking for a single word that will be contained
anywhere in the text string.

i.e. If I wanted to list all questions and answers that contain the
word "internet" how would I do it?

Thanks in advance

Joe

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.