title: What is the easiest way using T-SQL / MS-SQL to append a string to existing table cells?
body: <p>I have a table with a 'filename' column.
  I recently performed an insert into this column but in my haste forgot to append the file extension to all the filenames entered.  Fortunately they are all '.jpg' images.</p>
  
  <p>How can I easily update the 'filename' column of these inserted fields (assuming I can select the recent rows based on known id values) to include the '.jpg' extension?</p>