title: sql open query on active directory with multiple where clause
body: <p>I'm trying to limit the results using more than one WHERE clause like it is done in .net such as </p>
  
  <blockquote>
    <p>search.Filter = ("(&amp;(objectCategory=person)(physicaldeliveryofficename=*))</p>
  </blockquote>
  
  <p>but in SQL with open query on linked server I have this and works fine with only one where clause. </p>
  
  <blockquote>
    <p>SELECT Name, Department, Title, Telephonenumber Phone, physicaldeliveryofficename Location
    FROM OPENQUERY( ADSI, 
      'SELECT Name, Department, Title, Telephonenumber, physicaldeliveryofficename, SN, ST
      FROM ''LDAP://OU=XM,DC=nix,DC=com''
      WHERE physicaldeliveryofficename= ''*'' ')</p>
  </blockquote>
  
  <p>Is it even possible to have more than one WHERE clause? Thanks in advance for any assistance.</p>