title: Separate last name from a full name
body: <p>I want to display my data in this format:</p>
  
  <pre><code>First_Name  Mid_Name  Last_Name
  All         Ahmad     Khan
  </code></pre>
  
  <p>This is my code</p>
  
  <pre><code>select substr(customer_name1, 0, instr(customer_name1, ' ')-1) as first_name
       , substr(customer_name1, instr(customer_name1, ' ')+1) as mid_name 
       , ... as last_name
    from sttm_customers 
   where customer_name1 = 'ALI AHMAD KHAN'
  </code></pre>
  
  <p>Can anyone help me with how I should add last_name in my report?</p>