Is it possible to search for a word contained in a field which may contain lots of text, where this word may lie anywhere in the particular field.

For example, searching for "dance" and not picking up the word "attendance".

This should cause no problem if only searching for the first word in the field, but if the field contains much more text and I would be using the wildcard to get the search to look at all of the text.

Thanks in advance.

Graham

Like "dance *" or Like "* dance *" - will solve this particular problem but there will be others. For example if dance is followed by a punctuation mark.

Thanks for that Pat.

Graham