title: Case-insensitive REPLACE() in SQL Server 2000
body: <p>I have a field that contains strings such as 'Blah-OVER', 'Blah-OveR', etc. and want to select them without the 'over's.  This only catches the first case (so to speak) and not the others:</p>
  
  <pre><code>SELECT field as "before", REPLACE(field, 'OVER', '') as "after"
  </code></pre>
  
  <p>How do I just get them all to say 'Blah-' (preserving the case of what's left) without attempting to cover every case combination with another nested REPLACE function?</p>