Query syntax

[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.

 

[SusanV]

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"

 

[Nikos Yannacopoulos]

Jannie,

The criterion should be:

Like "*Palafox*"

HTH,
Nikos