title: Why doesn't If Not IsEmpty filter out empty strings?
body: <p>What is wrong with my <code>If</code> condition?</p>
  
  <pre><code>If Not IsEmpty(Wrkgps_L3) And Not IsEmpty(Wrkgps_L4) Then
      Wrkgps_L3L4 = Wrkgps_L3 &amp; "," &amp; Wrkgps_L4
  End If
  </code></pre>
  
  <p>The <code>Not</code> condition doesn't seem to work. The code within the <code>If</code> statement gets executed even when both <code>Wrkgps_L3</code> and <code>Wrkgps_L4</code> are empty strings.</p>
  
  <h2>Update:</h2>
  
  <p><code>Wrkgps_L3</code> and <code>Wrkgps_L4</code> are variables that contain results returned from a function. I noticed that <code>IsEmpty(Wrkgps_L3) = False</code> even though <code>Wrkgps_L3 = ""</code>. I had to rewrite my code to </p>
  
  <pre><code>If (Wrkgps_L3 &lt;&gt; "") And (Wrkgps_L4 &lt;&gt; "") Then
  </code></pre>
  
  <p>In any case, I am still intrigued to know why <code>IsEmpty</code> doesn't work on variables with <code>""</code>?</p>