title: SQL - Divide single column in multiple columns
body: <p>I have the following SQL question:</p>
  
  <p>How to divide a column (text inside) using the SELECT command into two separate columns with split text?</p>
  
  <p>I need to separate the text-data, using the space character.
  I know it is better to put an example to make it easy. So:</p>
  
  <pre><code>SELECT COLUMN_A FROM TABLE1
  </code></pre>
  
  <p>output:</p>
  
  <pre><code>COLUMN_A
  -----------
  LORE IPSUM
  </code></pre>
  
  <p>desired output:</p>
  
  <pre><code>COLUMN_A   COLUMN_B
  ---------  ----------
  LORE       IPSUM
  </code></pre>
  
  <p>Thank you all for the help.</p>