title: Separate value form field to row SQL Server 2000
body: <p>So,please help me to split value from table like below</p>
  
  <p>field A has value below</p>
  
  <pre><code>13974;14098;14237;14269;14317;14319;14392;14393;13 257;13983;13820
  </code></pre>
  
  <p>and i need to split and down value in row like below</p>
  
  <pre><code>file B
  13974
  14098
  14237
  14269
  ....
  </code></pre>
  
  <p>please help me to supports 
  many thanks </p>