I'm querying active directory using the syntax below. The query returns no rows even though distinguishedName contains the characters "XYZ". I'm attempting to do a "Like" comparison. Records are returned when I use this "where" clause: Where sn = ''*lber*''
From OpenQuery(ADSI,'Select distinguishedName
Where distinguishedName = ''*XYZ*''')