title: How to update inserted field in trigger
body: <p>Ok, my situation is like this: </p>
  
  <p>I have a table named Company, and I want to add a trigger after every record I add in this table that checks if the column Name does not end with 'LTD' then add 'LTD' at the end of the Name.</p>
  
  <p>I get an error saying Incorrect syntax near ')'. How would I do this?</p>
  
  <pre><code>Create Trigger [Add_LTD] on Company
  After Insert As
  Update Company
  Set Name = Name + ' LTD'
  If Exists (Select Name 
  From Inserted
  Where Name Not Like '% LTD')  
  </code></pre>