title: set feild to "1" for a certain string
body: <p>I am trying to set a field to "1" depending on whether the name has "LC" at the beginning, but my syntax doesn't appear to be right</p>
  
  <pre><code>SET @r_sql = '  UPDATE  mytables'+@r_mystuf+'
                  SET     feild1= ''1''
                  WHERE   category = ''4''
                  AND name LIKE ''LC%';                       
  
  exec (@r_sql);
  </code></pre>
  
  <p>Thanks</p>