CONTAINS, phrases and keywords

I'm getting some results from a CONTAINS query that I find odd. Here
is MyTable:

ID TheText
------------------------
1 two AND three
2 two three


and here is the query that I find odd:
SELECT * FROM MyTable WHERE CONTAINS(*, '"two OR three"')

that's a single quote followed by a double quote and then the reverse
at the end:

It returns row 1 but not row 2 in the results.

The only way I can explain why row 1 is being returned is if SQL is
throwing out both the AND in the data and the OR in the query. But if
that is the case why isn't row 2 being returned?

Anybody have any idea what's going on?

.

Relevant Pages

  • Odd and Even numbers
    ... I added a autonumber field to the table so now all the odd ... I intended to do a make table query selecting only the odd ... table with only business names, then do a make table query ...
    (microsoft.public.access.queries)
  • SQL Query question
    ... I have an odd one for everyone and hopefully someone can help me. ... the query is design to only select new records out of table one. ... years without fail until one day last week where the results from the ...
    (comp.databases.ms-sqlserver)
  • RE: Help on a query
    ... If you are going to have one query for even numbers and one for odd, ... Dave Hargis, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Syntax error in INSERT INTO statement
    ... You have at least one reserved word in your query - date. ... are suspect also. ... myTable is an odd table name. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Calculation problem in a query
    ... >in these three fields are in numuric format. ... > All data in this table is crearted by a query linked to a Sybase database. ... IF you can assume that [odd] should always be treated as zero if it's ...
    (microsoft.public.access.queries)