Find word INSTR 1

[IANGRAND]

I am running a query to find a user defined word within a string. Currently the code i use in the query is as follows:

Like [Forms]![IANS_FORM]![Text7] & "*"

However, this pulls through the text strings where the user defined word is at the start of the sentence. Is there a way to use INSTR within a query so it will pull through data no matter where the word occurs within the string?

If so, what will the code look like?

Regards

Ian Grand

 

[HarleyQuinn]

Like "*" & [Forms]![IANS_FORM]![Text7] & "*"

That will look for that word in any part of the field.

Hope this helps


HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.