title: Error : Subquery returned more than 1 value
body: <p>My query to update a whole table looks like this:</p>
  
  <pre><code>update works set nIndex = cast(replace(replace((select strIndex 
   from works), char(10), ''), char(10), '') as int)
  </code></pre>
  
  <p>However when I run it I get this error:</p>
  
  <blockquote>
    <p>"Subquery returned more than 1 value. This is not permitted when the
    subquery follows =, !=, &lt;, &lt;= , >, >= or when the subquery is used as
    an expression."</p>
  </blockquote>
  
  <p>.</p>