thanks for your answer.
select * from sys.dm_fts_parser('"PALette euro-palette"', 1031, NULL, 0)
i doesn't understand how this can help me to clarify how the words are splitting?
if i run this select i obtain 3 Rows as result with display terms: palette, euro and palette
special term is "exac match", occurence 1,2,3
What did me this say? That if the Searchword is "PAlette euro-palette" then FTS is looking for "palette euro palette" ?
And how can help me this if the searchword is "palette euro palette", and what i'm looking for is "palette euro-platte" with the minus sign? Well , your MS Link recommand use the LIKE instead of CONSTAIN , i will test this and look if is a difference in Performance.
EDIT: Is only the minus and plus sign problematic? or are other characters causing problems? If is only plus/minus signs, then i can change the search terms in our DataRows, normaly we copy the fields Description and Description 2 in the search description, i can substring the minus/plus signs before save the search description, then i have in description: "euro-palette", but in Search description "europalette" and then it must found the datarow when searching for "palette"