Query syntax

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jannie - 15 Apr 2005 14:36 GMT

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.

Reply to this Message

SusanV - 15 Apr 2005 14:41 GMT

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"

Signature

hth,
SusanV

> Pleasae help. I have several well names with the same basic name in
> them -
[quoted text clipped - 3 lines]
> that
> have the word Palafox in the name no matter where it is in the name.

Reply to this Message

Nikos Yannacopoulos - 15 Apr 2005 14:42 GMT

Jannie,

The criterion should be:

Like "*Palafox*"

HTH,
Nikos

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

Reply to this Message