title: Swap part of a value from one column to the other column?
body: <p>I have one table:</p>
  
  <blockquote>
    <p>dbo.Product</p>
  </blockquote>
  
  <p>Two columns:</p>
  
  <pre><code>SKU      Name
  ---      ----
  100A-B   (F102397) 1 AFFF C-103
  </code></pre>
  
  <p>I want to swap the SKU(100A-B) with JUST PART of Name(F102397) without the parenthesis in the SKU column.</p>
  
  <p>So it would be like:</p>
  
  <pre><code>SKU      Name
  ---      ----
  F102397  (100A-B) 1 AFFF C-103
  </code></pre>
  
  <p>And just FYI, the "Name" column isn't always consistent. Meaning it wouldn't always be like "1 AFFF C-103". Sometimes it can be "1AFFFC-103" or "1AFFF C-103", etc...but with different values. Would you need to worry about the second half when there are spaces/no spaces? </p>
  
  <p>Anyway of doing this? Any help would be greatly appreciated. :)
  I'm working with SQL-Server 2005.</p>
  
  <p>** <strong>EDIT</strong> **</p>
  
  <p>More examples and what I'm trying to get from it.</p>
  
  <p>Example of what most of the data looks like. Its a mess with the spaces in some of the SKU's but that's something I DON'T have the option of changing.</p>
  
  <p>And I am keeping the () in the "Name" field.</p>
  
  <pre><code>SKU      Name
  ---      ----
  100A-B   (F102397) 1 AFFF C-103
  101 A-F  (F011889) TEST ITEM
  101 U-X  (F060796) TEST ITEM 2
  102A-B   (F102497) TEST ITEM 3
  </code></pre>
  
  <p><strong>RESULT</strong></p>
  
  <pre><code>SKU      Name
  ---      ----
  F102397  (100A-B) 1 AFFF C-103
  F011889  (101 A-F) TEST ITEM
  F060796  (101 U-X) TEST ITEM 2
  F102497  (102A-B) TEST ITEM 3
  </code></pre>