title: Split comma delimited string --> FUNCTION db.CHARINDEX does not exist
body: <p>I need to split comma delimited string into a second columns 
  I have the following table :</p>
  
  <pre><code>CL1     POS                 POS2     LENGHT     ALLELE
  1       3015108,3015109              5          A
  2       3015110,3015200              10         B
  3       3015200,3015300              15         C
  4       3015450,3015500              20         D
  5       3015600,3015700              15         E
  </code></pre>
  
  <p>I want to split the numbers after the comma into a second column POS2
  So it should like that </p>
  
  <pre><code>CL1     POS                 POS2     LENGHT     ALLELE
  1       3015108             3015109  5          A
  2       3015110             3015200  10         B
  3       3015200             3015300  15         C
  4       3015450             3015500  20         D
  5       3015600             3015700  15         E
  </code></pre>
  
  <p>So I've queried the following : </p>
  
  <pre><code>INSERT INTO MyTable (POS2)
  SELECT RIGHT(POS, CHARINDEX(',', POS) + 1 ) FROM MyTable ;
  
  
   It returns an error : 
   ERROR 1305 (42000): FUNCTION test.CHARINDEX does not exist
  </code></pre>