title: To insert single quote values into the table using "insert into"
body: <p>I tried to insert some data from one table (tableA) 
   into another table (tableB) using bulk insert but cannot succeeded because the tableA data has got one value->     <code>BERMUDA 23''-24''</code> 
  when it tries to enter this value it raise error as </p>
  
  <pre><code>String or binary data would be truncated. 
  </code></pre>
  
  <p>My query is </p>
  
  <pre><code>insert into tableA 
  select size from tableB
  </code></pre>
  
  <p>i try with replace the single quote with empty space but as its size we should enter the data with single quote only.
  Please suggest the way out.</p>