Answers.Body: <p>(EDITED) You could use a combination of eg a smart group for Orgs with name contains 'embassy of', and then Tag every record that has 'the US', then search for contacts that are in Embassy group and US Tag and set 'search operator' to AND
  "Search Operator
  Determines whether your criteria are combined with AND statements, or combined with OR statements. For example, you may want to find all individuals who are in the Volunteers group AND who have a Volunteer Training activity recorded for them. In this case use the AND operator. If you need to find everyone who is in the Volunteers group OR has a Volunteer Training activity recorded, use the OR operator."</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-05T09:40:08.407Z
Answers.Text: I presume the is for an Advanced Search.  If so, it won't work.  Although you can choose to  combine criteria in different fields with an AND or an OR, multiple selections for the same field (in this case the Group(s) field) are always combined with OR.  So this would return all organisations with "embassy of" in their name and also all organisations with "the US" in their name.
Answers.UserDisplayName: JoAnne
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-06T06:35:41.403Z
Answers.Text: SO would it work if one was a Smart Group and the other a Tag? Obviously not a 'dynamic' solution but ...
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-06T10:47:49.293Z
Answers.Text: Yes, that works, because they are different fields, so you can join them with AND or OR . AND is the default option, so if you have tagged "the embassy" and put "the US" and "the UK" into a smart group the result will be "the embassy of the US" and "the embassy of the UK".
Answers.UserDisplayName: JoAnne
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-02T09:50:33.613Z
Answers.LastActivityDate: 2015-06-06T23:14:19.197Z
Answers.LastEditDate: 2015-06-06T23:14:19.197Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>Based on the revised question you should:</p>
  
  <ol>
  <li>Use search builder to create a "countries of interest" (smart) group. "Also include contacts where" is the OR operator. I would suggest you specify % UK% and % US% etc as this will at least eliminate options where uk or us are in the centre of an organisation name.</li>
  <li>Use search builder or advanced search to create a (smart) group for organisations with names like %embassy of%.</li>
  <li>Use search builder to find the organisations in both groups then do with them what you will.</li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-04T03:17:20.663Z
Answers.LastActivityDate: 2015-06-04T03:17:20.663Z
Answers.UserDisplayName: JoAnne
Answers.Body: <p>Try the search builder:</p>
  
  <p>Include contacts where first name="john" and last name="doe"
  +also include contacts where first name="john" and last name="coltrane"</p>
  
  <p>should get you the list you want</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-02T08:54:02.217Z
Answers.Text: Sorry, I should have asked a more precise question. What I really want to search is organisations that share a part of the name, i.e. 'embassy of' but then add more attributes with or - so 'embassy of' AND 'the US' or 'the UK'. Can't work that out using search builder.
Answers.UserDisplayName: user50537
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-02T10:09:12.427Z
Answers.Text: You might edit your question then to improve this thread.
Answers.UserDisplayName: Martin Peth
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-02T08:44:03.697Z
Answers.LastActivityDate: 2015-06-02T08:44:03.697Z
Answers.UserDisplayName: Xavier
Body: <p>How can I search for organisations that share a part of the name (i.e. 'embassy of') but then add more attributes with <code>OR</code>? So, for example: </p>
  
  <pre><code>'embassy of' AND ('the US' OR 'the UK')
  </code></pre>
  
Tags: <search><search-results>
Title: 'OR' search syntax
ThreadText: # 'OR' search syntax
  
  (Asked by: username_0 on 2015-06-02)
  
  How can I search for organisations that share a part of the name (i.e. 'embassy of') but then add more attributes with `OR`? So, for example:
  
  ```
  'embassy of' AND ('the US' OR 'the UK')
  
  ```
  
  **Tags:** search, search-results
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2015-06-02. Score: 3
  
  (EDITED) You could use a combination of eg a smart group for Orgs with name contains 'embassy of', and then Tag every record that has 'the US', then search for contacts that are in Embassy group and US Tag and set 'search operator' to AND
  "Search Operator
  Determines whether your criteria are combined with AND statements, or combined with OR statements. For example, you may want to find all individuals who are in the Volunteers group AND who have a Volunteer Training activity recorded for them. In this case use the AND operator. If you need to find everyone who is in the Volunteers group OR has a Volunteer Training activity recorded, use the OR operator."
  
  > **Comments:**
  > **username_2**: I presume the is for an Advanced Search.  If so, it won't work.  Although you can choose to  combine criteria in different fields with an AND or an OR, multiple selections for the same field (in this case the Group(s) field) are always combined with OR.  So this would return all organisations with "embassy of" in their name and also all organisations with "the US" in their name.  
  > **username_1**: SO would it work if one was a Smart Group and the other a Tag? Obviously not a 'dynamic' solution but ...  
  > **username_2**: Yes, that works, because they are different fields, so you can join them with AND or OR . AND is the default option, so if you have tagged "the embassy" and put "the US" and "the UK" into a smart group the result will be "the embassy of the US" and "the embassy of the UK".  
  
  ---
  
  ### Answer by username_2 on 2015-06-04. Score: 2
  
  Based on the revised question you should:
  
  1. Use search builder to create a "countries of interest" (smart) group. "Also include contacts where" is the OR operator. I would suggest you specify % UK% and % US% etc as this will at least eliminate options where uk or us are in the centre of an organisation name.
  2. Use search builder or advanced search to create a (smart) group for organisations with names like %embassy of%.
  3. Use search builder to find the organisations in both groups then do with them what you will.
  
  
  ---
  
  ### Answer by username_3 on 2015-06-02. Score: 2
  
  Try the search builder:
  
  Include contacts where first name="john" and last name="doe"
  +also include contacts where first name="john" and last name="coltrane"
  
  should get you the list you want
  
  > **Comments:**
  > **username_0**: Sorry, I should have asked a more precise question. What I really want to search is organisations that share a part of the name, i.e. 'embassy of' but then add more attributes with or - so 'embassy of' AND 'the US' or 'the UK'. Can't work that out using search builder.  
  > **username_4**: You might edit your question then to improve this thread.  
  
  ---
  
  