Query syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Pleasae help. I have several well names with the same basic name in them -
Palafox but some may be J.B. Palafox, some Palafox, Some Palafox Exploration
and so on. How can I say in my criteria in my query to pull ALL wells that
have the word Palafox in the name no matter where it is in the name.
 
In the criteria field of the query, enclose the search term in asterisks,
i.e., *Palafox*
If writing SQL, use WHERE [fieldname] LIKE "Palafox" rather than WHERE
[fieldname] = "Palafox"
 
Back
Top