title: Access 2013 SQL, searching for : in a specified cell
body: <p>I am working on a SQL statement for an Access 2013 database. I have two tables as similar to these two:</p>
  
  <p>T1:</p>
  
  <pre><code>ticketID         endResult
  1
  2
  </code></pre>
  
  <p>T2:</p>
  
  <pre><code>ticketID         Description
  1                Return: other text
  2                some description
  </code></pre>
  
  <p>The goal is to update T1.endResult with <code>Fixed: Return</code> whenever there is a ':' in the T2.Description column. This is all being done in Access 2013, using SQL statements. Currently I am doing the following:</p>
  
  <pre><code>UPDATE T1
  INNER JOIN T2 ON T1.ticketID = T2.ticketID
  SET T1.endResult = ('Fixed: ' &amp; LEFT(T2.Description, :))
  WHERE (T1.endResult IS NULL AND (InStr(T2.Description, :,1)))
  </code></pre>
  
  <p>Whenever I run this, access prompts me to input the value of : . How could I search the description just for that one symbol? Now that I use the LEFT of : as well as there could be other values instead of Return that could be returned and still be valid. </p>