Strange behavior of CONTAINS function

Hello,

I have a query that uses the CONTAINS function but I got a strange
result. I have a table with product information on various tv's.

Part of the query is:
WHERE CONTAINS(sb_pvomschrijving, ' "PDP" AND "436" ')

To my opinion this query has to return all records where the field
sb_pvomschrijving contains the words PDP and 436.

For example, I get this record:
Pioneer PLASMA PDP 436 SXE

but not with an '-' in the product description, like:
Pioneer PLASMA PDP-436 SXE

This looks strange to me as also in the second situation, the words PDP
and 436 are in the field. I also tried using wildcards but the even
don't return the expected results.

WHERE CONTAINS(sb_pvomschrijving, ' "PDP*" AND "*436" ')
also doesn't return the expected value with an '-' in it.

Has anyone some experience with this problem?
Best regards,
Pim

.

Relevant Pages

  • Re: Search Key not found in any record - error message
    ... Something very strange happening. ... If I just run the query it returns all the records except the problem ... I cannot then click on the criteria box in the field column but I can ... Could it be the actual size of the database? ...
    (microsoft.public.access.gettingstarted)
  • Re: Strange Query Behavior (Repost)
    ... > Sorry for the cross post, but this behavior is strange enough that I ... > I'm running into a strange problem with an Access 2K query. ... pass-through queries should eliminate the problem. ...
    (microsoft.public.access.formscoding)
  • Re: Strange Query Behavior (Repost)
    ... > Sorry for the cross post, but this behavior is strange enough that I ... > I'm running into a strange problem with an Access 2K query. ... pass-through queries should eliminate the problem. ...
    (microsoft.public.access.queries)
  • Re: DateTime field showing unwanted Time
    ... That is strange. ... query or in control box you can use format: ... the same in every table and database I open. ... The time portion is 12:17:04 AM regardless of what table or database I open. ...
    (microsoft.public.access.setupconfig)
  • RE: Error with DTS package
    ... At least: for me it's strange! ... using DTS-packages based on queries. ... The query on which this is based is the ... double click the arrow for the transform data task ...
    (microsoft.public.sqlserver.dts)
Loading