title: How do I run an SQL update query using a like statement
body: <p>I am trying to update a field in a table using an SQL update query where there is a like statement referencing a value in another table. They syntax unfortunately is not working.  Below is my code.   In short, I am trying to put a '1' in the field 'Query07ParolaChiave' in the table 'tblSearchEngine01' when the value located in table 'tblsearchengine07' is present in the field 'tblMasterListOfEventsNotes' located in the table 'tblSearchEngine01'.  I think my code is almost complete but there is a syntax issue which i cant find. </p>
  
  <pre><code>st_sql = "UPDATE tblSearchEngine01, tblSearchEngine07 SET tblSearchEngine01.Query07ParolaChiaveSelect = '1' WHERE ((([tblSearchEngine01].[tblMasterListOfEventsNotes]) Like " * " &amp; [tblsearchengine07].[ParolaChiave] &amp; " * "))"
      Application.DoCmd.RunSQL (st_sql)
  </code></pre>