title: String compare in SQL Server !
body: <p>I have two table T1 and T2.I used Sql server 2000.</p>
  
  <p><strong>Table T1</strong></p>
  
  <pre><code>ID   WorkerName      Group
  1    Rahim,Karim        1
  2    Kamal,Adam         3
  3    Rahim,Karim        1
  </code></pre>
  
  <p><strong>Table T2</strong> </p>
  
  <pre><code>WorkerID   WorkerName 
  1          Rahim
  2          Karim
  3          Kamal
  4          Adam
  </code></pre>
  
  <p>I want to replace Worker Name on T1 with 1st WorkerID on T2 Like this.</p>
  
  <p><strong>Table T1</strong>  </p>
  
  <pre><code>   ID   WorkerName      Group
     1      1             1
     2      3             3
     3      1             1
  </code></pre>
  
  <p>Is there any solution for this?</p>