title: Applying Quotes Across Multiple Lines in SSMS
body: <p>Is there a keyboard function that applies single quotes across a list of values? I have 10 IDs that I have copied from an Excel spreadsheet and I would like to execute a query that uses an IN clause on this list, and I don't want to manually add single quotes and comma around each item.</p>
  
  <p>For example:</p>
  
  <pre><code>SELECT * FROM tbl WHERE someValue IN (
  ABC1
  ABC2
  ABC3
  ABC4
  )
  </code></pre>
  
  <p>I want to highlight the values and using a keyboard shortcut turn the list into:</p>
  
  <pre><code>SELECT * FROM tbl WHERE someValue IN (
  'ABC1',
  'ABC2',
  'ABC3',
  'ABC4'
  )
  </code></pre>
  
  <p>I got how to get quote in the beginning using SHIFT + ALT (select the list and type single quote <strong>'</strong>)
  Courtesy: <a href="https://dba.stackexchange.com/questions/96371/applying-quotes-across-multiple-lines/96378#96378?newreg=5c3f55c24a924dd28cd9834ad8a625ae">Link</a>.</p>
  
  <p>But how to do the same at the end of each item to add a single quote and comma (<strong>',</strong>)</p>
  
  <p>Thank you in advance</p>