Help! I'm using the following to open a recordset and grab all the records that are a close match. Basically I have questions that aply for more than 1 subject that are exactly the same. I need to have the search criteria match using LIKE or similar. Any ideas?

Set rcdTemp2 = dbsData.OpenRecordset("select * from questions where QuestionName like '" & Mid(strTemp, 1, 6) & "'")