title: SSRS Expression Multiple IIF Lcase and replace
body: <p>I have the following expression :</p>
  
  <pre><code>=LCase(Replace(Fields!Column.Value,"ly",""))
  </code></pre>
  
  <p>which is fine for replacing the end of a word so Monthly would be Month, but I can't quite get the syntax right for if its <code>"ly"</code> OR <code>"LY"</code> .</p>
  
  <p>Have tried <code>IIF</code> and <code>SWITCH</code> but my syntax is wrong somewhere.</p>