I have this small dataBase that contains a Memo Field.
I need to be able to search this memo field for particular words.
Being a DataBase ignorant soul. I am at a loss.
Can anyone help?
Here is an example of a SQL statement the program currently uses

set mRS = mDB.OpenRecordset("select * from codeitems where id = " & msKey)
'
'
I need it something like
set mRS = mDB.OpenRecordset("select * from codeitems where example contains the word "Bookmark").



My DataBAse for Dummies book does not cover this situation.


John G