title: Firebird Database Split String on Field
body: <p>Currently working with a Firebird 1.5 database and attempting to pull the data in the correct format natively with SQL. </p>
  
  <p>Consider the following database:</p>
  
  <pre><code>ID | Full Name
   1   Jon Doe
   2   Sarah Lee 
  </code></pre>
  
  <p>What I am trying to achieve is a simple split on the full name field (space) within a query.</p>
  
  <pre><code>ID | First Name | Last Name
  1     Jon          Doe
  2     Sarah        Lee 
  </code></pre>
  
  <p>The issue faced is Firebird POSITION() was introduced in v2.0.  Is there any known workaround to split on a space that anyone has come across?   </p>
  
  <p>Much appreciate your assistance! </p>