title: MS Access "Invalid Procedure Call" matching first half of email address with email addresses from another table
body: <p>I'm running into a "Invalid Procedure Call" when running the below code on tables in an Access 2010 db but it is working in Access 2000 db.</p>
  
  <p>I didn't write this code, I know it is compairing text before the '@' symbol but I would love to hear an explanation of what the specific syntax I am looking at here does: "Left(Nz(t1.Username,''),InStr(Nz(t1.Username,''),'@')-1) = Left(Nz(t2.email,''),InStr(Nz(t2.email,''),'@')-1)
      ))&lt;>False));"</p>
  
  <pre><code>SELECT
      t1.ID,
      t1.Username AS Email
  FROM USERS AS t1
  WHERE (((Exists (SELECT * 
              FROM LICENSE AS t2 
              WHERE Left(Nz(t1.Username,''),InStr(Nz(t1.Username,''),'@')-1) = Left(Nz(t2.email,''),InStr(Nz(t2.email,''),'@')-1)
      ))&lt;&gt;False)); 
  </code></pre>