Search using SQL LIKE query - can anyone see what the problem is?

I have a search button which when pressed is supposed to perform a search.

A snippet of the code this (to save me typing it all):


Set searchRS = New ADODB.Recordset
searchRS.Open "Select * From Task Where TaskInfo= '%txtSearch%' Order By TaskID", db, adOpenStatic, adLockOptimistic


I then send the results back to the form, but there is nothing returned. The form displays saying no results found.

"Select * From Task Where TaskInfo like '%txtSearch%' Order By TaskID", db, adOpenStatic, adLockOptimistic

like instead of =?