title: How do I Select characters to the left of a ',' and then characters to the right of a ','?
body: <p>Currently I've gotten as far as </p>
  
  <pre><code>SELECT
      DESCRIPTION,
      LEFT(DESCRIPTION, 
           CASE 
             WHEN CHARINDEX(',', DESCRIPTION) = 0 THEN LEN(DESCRIPTION) 
             ELSE charindex(',', DESCRIPTION) - 1 
           END) AS LEFTDESCRIPTION,
      RIGHT(DESCRIPTION, 
            CASE 
               WHEN CHARINDEX(',',REVERSE(DESCRIPTION)) = 0 THEN '' 
               ELSE charindex(',', DESCRIPTION) - 1 
            END) AS RIGHTDESCRIPTION 
  FROM TABLE
  </code></pre>
  
  <p>But the RIGHT portion doesn't seem to be correct, for example:</p>
  
  <p>It gets a description of example,this and returns "ample,this" rather than just "this"</p>