Classic queries are case sensitive when using the 'equals' operator. Case sensitive must be unchecked at the element level in order to bypass the case sensitivity default value.
When creating a classic query, the results are different when searching for contacts by email, name, or anything with text in it using the 'equals' operator. However, the new query gives the correct count.
Why? Classic queries are case sensitive by default when using the 'equals' operator. The option needs to be unchecked on the individual item.
Resolving the problem
- Go to View under Queries.
- Place a check mark next to the name of the Query.
- Click Edit Query.
- Click Edit icon.
- Uncheck Case Sensitive then click Apply Changes.
- Click Save and Calculate.
Note: Unchecking the Case Sensitive box for the entire query does not work.