title: How can I use LEFT & RIGHT Functions in SQL to get last 3 characters?
body: <p>I have a <code>Char(15)</code> field, in this field I have the data below:</p>
  
  <pre><code>94342KMR
  947JCP
  7048MYC
  </code></pre>
  
  <p>I need to break down this, I need to get the last RIGHT 3 characters and I need to get whatever is to the LEFT. My issue is that the code on the LEFT is not always the same length as you can see.</p>
  
  <p>How can I accomplish this in SQL?</p>
  
  <p>Thank you</p>