title: Stop SQL Server Evaluating Useless UPPER/LOWER In WHERE Clause?
body: <p>it seems that despite the fact that SQL Server does not match on case in a WHERE clause it still honours UPPER/LOWER in a WHERE clause which seems to be quite expensive. Is it possible to instruct SQL Server to disregard UPPER/LOWER in a WHERE clause?</p>
  
  <p>This might seem like a pointless question but it's very nice to be able to write a single query for both Oracle and SQL Server.</p>
  
  <p>Thanks, Jamie</p>