title: How can I reduce the complexity of this expression?
body: <p>I have an IIF in my query that says:</p>
  
  <pre><code>IIF(ApplicationDate BETWEEN @START and @END
  AND convert(varchar,LEFT(AAA.LastName,2)+LEFT(BBB.CITY,2)+BBB.ZIPCode+RIGHT(CCC.SSN,4)) in &lt;list&gt;,THIS,THAT)
  </code></pre>
  
  <p>Where 'list' is 13,000 varchar strings that look like 'MCSM349954987'</p>
  
  <p>When I run this query I get an error message that says "Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them."</p>
  
  <p>Is there a way I can simplify this so my query will run?</p>