title: Use of function calls in stored procedure sql server 2005?
body: <p>Use of function calls in where clause of stored procedure slows down performance in sql server 2005?</p>
  
  <pre><code>SELECT * FROM Member M 
  WHERE LOWER(dbo.GetLookupDetailTitle(M.RoleId,'MemberRole')) != 'administrator' 
  AND LOWER(dbo.GetLookupDetailTitle(M.RoleId,'MemberRole')) != 'moderator' 
  </code></pre>
  
  <p>In this query GetLookupDetailTitle is a user defined function and LOWER() is built in function i am asking about both.</p>