retreive a word

JonyBravo

Registered User.
Local time
Today, 03:12
Joined
Jan 17, 2006
Messages
89
Hi there

I have a table in my database with a field called description. Imagine if one of my discriptions is "I learn a lot in access world forums". I need a query that if I look only for a word "access" will retrieve this discription. Is this possible to be done in access?

Thanks
 
You can use the following as your criterion:
LIKE "*access*"

e.g.
SELECT *
FROM myTable
WHERE description LIKE "*access*"

hth
Stopher
 
Thank you Stopher
 
You PM'd me with the question:

"How can I use a variable called txtWord instead the word access?"

Like '*' & txtWord & '*'


hth
Stopher

BTW, it's better to respond to the forum rather than PM someone for an answer. You'll most likely get a faster response.
 

Users who are viewing this thread

Back
Top Bottom