Answers.Body: <p>Try changing the search condition of the Search Builder 
  ignore is_primary flag </p>
  
  <p>look for:
  contact -> country -> home -> is not null (also change the address type)
  contact -> contact type = Individual </p>
  
  <p>by this way you can select all the record with country field null also you can use batch update </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-22T15:44:02.943Z
Answers.Text: Thanks for the answer. Tried different options using 'is not null' but it still showed all contacts in the results, not just the ones with an empty field.
  
  Just updated the version to 4.6 and now it's working...
Answers.UserDisplayName: Rose Lanigan
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-21T13:55:07.910Z
Answers.LastActivityDate: 2015-07-21T13:55:07.910Z
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Body: <p>I know I have contacts with no Country - this was something we came across recently when a colleague tried to use the proximity search and known contacts didn't appear. I've used Batch update to update a fair few I knew about, but when I use the Search Builder now to check for Contacts > Country > Primary > 'Is empty' or '≠' 'United Kingdom' and it comes back with nothing. But scrolling through the records, I can see there are still some records with no Country?</p>
  
  <p>Am I not using the Search Builder properly or is there a bug? I'm using v4.4.13</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-07-21T13:31:40.713Z
Comments.Text: Are there contacts that have a primary address with other fields filled in, e.g. street address, but no country?
Comments.UserDisplayName: davejenx
Tags: <search><search-results><search-builder>
Title: Problems with Search Builder: Trying to find records with empty Country field
ThreadText: # Problems with Search Builder: Trying to find records with empty Country field
  
  (Asked by: username_0 on 2015-07-21)
  
  I know I have contacts with no Country - this was something we came across recently when a colleague tried to use the proximity search and known contacts didn't appear. I've used Batch update to update a fair few I knew about, but when I use the Search Builder now to check for Contacts > Country > Primary > 'Is empty' or '≠' 'United Kingdom' and it comes back with nothing. But scrolling through the records, I can see there are still some records with no Country?
  
  Am I not using the Search Builder properly or is there a bug? I'm using v4.4.13
  
  **Tags:** search, search-results, search-builder
  
  > **Comments:**
  > **username_1**: Are there contacts that have a primary address with other fields filled in, e.g. street address, but no country?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2015-07-21. Score: 1
  
  Try changing the search condition of the Search Builder
  ignore is\_primary flag
  
  look for:
  contact -> country -> home -> is not null (also change the address type)
  contact -> contact type = Individual
  
  by this way you can select all the record with country field null also you can use batch update
  
  > **Comments:**
  > **username_0**: Thanks for the answer. Tried different options using 'is not null' but it still showed all contacts in the results, not just the ones with an empty field.  Just updated the version to 4.6 and now it's working...  
  
  ---
  
  