title: How to split space delimited field into rows in SQL Server?
body: <p>I found <a href="http://www.logiclabz.com/sql-server/split-function-in-sql-server-to-break-comma-separated-strings-into-table.aspx" rel="nofollow noreferrer">this function</a> which returns three rows for the following query: </p>
  
  <pre><code>select * from dbo.split('1 2 3',' ') 
  </code></pre>
  
  <p>However, I need to use values from a field instead of '1 2 3'. </p>
  
  <p>I tried: </p>
  
  <pre><code>select * from dbo.split(select top 1 myfield from mytable,' ')
  </code></pre>
  
  <p>But it fails saying incorrect syntax.</p>
  
  <p>It doesn't have to use the function above, so feel free to recommend another function or different way to go about it. To clarify, I only need to parse the values from a single row of a single field.</p>