title: How can I insert a hyphen in the middle of an alpha numerical string?
body: <p>My query currently produces output with the <code>Part Number</code> as one value:</p>
  
  <pre><code>SELECT UPPER(PartNumber)AS "Part Number",
      INITCAP(PartDesc)AS "Description"
  FROM Part 
  WHERE UnitPrice*UnitsOnHand &lt;1000
  ORDER BY PartDesc DESC;
  
  Part Number Description                            
  ----------- ----------------------------------------
  BA74        Baseball Bat                             
  CA14        Skillet - 12 Inch                        
  AZ52        Roller Skates                            
  </code></pre>
  
  <p>The result should still be 2 columns, but modified:</p>
  
  <pre><code>Part Number Description                            
  ----------- ----------------------------------------
  BA-74       Baseball Bat                             
  CA-14       Skillet - 12 Inch                        
  AZ-52       Roller Skates                            
  </code></pre>
  
  <p><code>Part Number</code> will always have alpha/numeric characters, <code>Description</code> is just alpha. What I need to be able to do is insert a hyphen between the alpha and numerical characters. They will always be alpha/numeric never change.</p>