Find a record that contains a word in a string

[knowshowrosegrows]

I have a table that has cells with "unable to reach", "unable to reach after 5 attempts", "Unable x 5", etc. in the [Other] field.



How do I query for the word "unable" in the [Other] field and all those above records will result?

Thanks so much!

[June7]

Try:

SELECT * FROM table WHERE [Other] LIKE "*unable*";

[knowshowrosegrows]

Fantastic!!!!