title: how to put a split function into query select sql
body: <p>I want to put a split function into select like </p>
  
  <pre><code>CREATE TABLE #tmp(id INT ,codes VARCHAR(10))
  
  
  INSERT INTO #tmp(id,codes) VALUES (1,'1;2;3')
  
  
  SELECT id , BaseSplit(codes,';')  FROM #tmp 
  </code></pre>
  
  <p>but how ??? </p>