title: Trying to replace a certain character in SSRS
body: <p>I am trying to replace a the charater <code>0</code> when pulling through a report. I have entered the expression below and when I run my report I get a <code>#Error</code> any hints on what I am doing wrong?</p>
  
  <p>Thanks</p>
  
  <p><code>=IIf(Fields!HomeAddress2.Value &amp; " " &amp; Fields!HomeAddress3.Value &amp; " " &amp;Fields!HomeAddress4.Value  = 0, Fields!HomeAddress2.Value &amp; " " &amp; Fields!HomeAddress3.Value &amp; " " &amp;Fields!HomeAddress4.Value, "")</code></p>