sql server full text search: Diwen,
You can use the FORMSOF(INFLECTIONAL()) keyword in either CONTAINS or
CONTAINSTABLE, for example:

SELECT titel, author, datum, text_typ
FROM texttable_intern
WHERE CONTAINS(content, 'FORMSOF (INFLECTIONAL, Dresdner)') or
CONTAINS(content, 'FORMSOF (INFLECTIONAL, Bank)')

Additionally, as "Dresdner Bank" (within double quotes) is considered a
multiple word "phrase" and is not a <simple_term> as a phrase, see SQL
Server 2000 BOL title "CONTAINS" - "Specifies that the plural and singular,
as well as the gender and neutral forms of nouns, verbs, and adjectives
should be matched. The various tenses of verbs should be matched too. A
given <simple_term> within a <generation_term> will not match both nouns and
verbs."
Also, I suspect that you *might* be using the German word breaker ("Language
for Word Breaker") for the FT enable column text and the German and
depending upon your OS Platform (Win2K or Win2003 ?), and language setting,
you may see different results.

Regards,
John




[quoted text, click to view]

Hi,

I would like to form contains inquiry (phrase search) in MS SQL Server
fulltext. But there are Probleme in the formulation string with the
quotation mark " " and ' '. How may I formulate that ('"Dresdner
Bank"') correct in java?



ResultSet rs = wstmt.executeQuery("SELECT titel, author, datum, text_typ
FROM texttable_intern WHERE CONTAINS (content, ' "Dresdner Bank" ')");



"Dresdner Bank" ist the search phrase.





Thank you





Diwen


--