title: Update a column in Table with Query (text)
body: <p>I have a table in a database which contains query statements in the columns. I need to update this. Is there any way I can update this It seems to be giving me an error: </p>
  
  <pre><code>UPDATE Items
  SET Query = 'SELECT isnull((sum(OrigDocAmt) ),0) amount from AP where Acct in (1234) and Status='O' and Doc in ('CK') {SLLocCode}'
  WHERE ID='111'
  </code></pre>
  
  <p>It gives me an error because it considers 'O' as a separate string. Is there a way that I can do this like in python "What's up". 
  Not sure why it was setup this way but it was done so by my predecessor. Please help. </p>