Hi,
I am using fulltextQuery for getting MOSS Search results programatically.
Here are the queries that i am using:
1. SELECT CustomerName,FrequentItems, CustomerAddress FROM Scope() WHERE "Scope" = 'Customers' AND CONTAINS(CustomerAddress,'"Netherlands, The"') ORDER BY Rank DESC
When I execute the above query, I am getting the customers who are having Netherlands as CustomerAddress in the resultset.
MetaData for the CustomerAddress will be like this:
Canada
Netherlands
Netherlands, the
France
France, Metroploitan
So, I expect the customers with the Customer Address having Netherlands, the in the resultset. but which is not happening.
2. SELECT CustomerName,FrequentItems, CustomerAddress FROM Scope() WHERE "Scope" = 'Customers' AND CONTAINS(CustomerAddress,'"France, Metropolitan"') ORDER BY Rank DESC
But this query is working as expected, it returns the results which has France, Metropolitan in customer address.
how can I get the results matching my search criteria, in case my input has comma(,) in the first case.
Is this somthing todo with common words?
Thanks in Advance for any help.
Regards.