search any part of text field

[Simon Davies]

I need to set a criteria in a query which will search and return a word in
any part of the field.
I have used the Like[word]&"*" criteria but it only works on the first
word.

Any help or advice gratefully recieved

 

[Tom Lake]

I need to set a criteria in a query which will search and return a word in
any part of the field.
I have used the Like[word]&"*" criteria but it only works on the
first
word.

Try

Like "*" & [word] & "*"

This will find the word anywhere in the field.

Tom Lake

 

[Newbie]

How about Like "*" & [word] & "*"

 

[Simon Davies]

Many thanks

How about Like "*" & [word] & "*"

I need to set a criteria in a query which will search and return a word in
any part of the field.
I have used the Like[word]&"*" criteria but it only works on the first
word.

Any help or advice gratefully recieved

 

[Simon Davies]

Brilliant - many thanks

I need to set a criteria in a query which will search and return a word in
any part of the field.
I have used the Like[word]&"*" criteria but it only works on the
first
word.

Try

Like "*" & [word] & "*"

This will find the word anywhere in the field.

Tom Lake