title: regex replace: '[A-Z]'' to [A-Z]' - I can't preserve the letter in in the string
body: <p>My google foo is failing me...</p>
  
  <p>I have a file (well over 2 gig's) that has a SQL format problem. So I need a regex that will update the following examples (remember, I don't know how many there are or what the letters are):</p>
  
  <ol>
  <li>'N'' should be changed to N'</li>
  <li>'L'' should be changed to L'
  etc</li>
  </ol>
  
  <p>I've tried (within VIM and sed):</p>
  
  <pre><code>s/'[A-Z]''/$1'/
  </code></pre>
  
  <p>but that just produces:</p>
  
  <pre><code>'N'' -&gt; '$1'
  </code></pre>