title: Problem matching data in tables using regex
body: <p>Here, I want to update categoryName for image2 wherever characters in <strong>categoryID (image2)</strong> matches with <strong>categorID (image1)</strong>. however, I want for categoryID <strong>&quot;AA BB&quot;(image2)</strong> should have category name updated as Archeology, Business. But , I am not getting the desired result with the query that I have pasted here.</p>
  <p><img src="https://i.stack.imgur.com/OfiUX.png" alt="enter image description here" /></p>
  <p><img src="https://i.stack.imgur.com/sM7GW.png" alt="enter image here" /></p>
  <pre><code>UPDATE image2 INNER JOIN [image1] ON image2.CategoryID = image1.CategoryID SET image2.CategoryName = image1.CategoryName
  WHERE ((([image1].CategoryID) Like &quot;*[A-Z\s]*&quot;));
  </code></pre>