title: How to parse a column delimited with a comma?
body: <p>I have the following select query (using SQL Server 2017):</p>
  
  <pre><code>SELECT PAYMENT_INFO
  FROM CHECK_PAYMENT
  WHERE (PAYMENT_FISCAL_DATE = '01/19/2018')
    AND (TENDER_MEDIA_NAME LIKE 'PaymentCard%')
  ORDER BY VOID, TENDER_MEDIA_NAME
  </code></pre>
  
  <p>The output is a very long semicolon delimited string that I want to just return the first two fields.</p>
  
  <p>Current output:</p>
  
  <pre><code>AmericanExpress;XXXXXXXXXXX4111;;;;41.47;8.00...............
  MasterCard;XXXXXXXXXXXX7971;;;;40.22;10.00................
  Visa;XXXXXXXXXXXX6302;;;;11.94;0.00....................
  </code></pre>
  
  <p>Desired output:</p>
  
  <pre><code>AmericanExpress;XXXXXXXXXXX4111
  MasterCard;XXXXXXXXXXXX7111
  Visa;XXXXXXXXXXXX6111
  </code></pre>
  
  <p>If possible I would like these separated into two columns.</p>
  
  <p>I have looked through stack and found similar questions but have not found an answer that works or that I can figure out how to modify for my situation.</p>