"webbi" <ma***@mgm.at> wrote in message
news:4e**************************@posting.google.c om...
Hallo!
Ich habe eine Tabelle mit einem Datensatz in ein Feld den Wert
'Technaflon Nasskamine' hat.
Wenn ich so Suche wir der Datensatz gefunden:
Select * from namen where contains(*, '"Technaflo*"')
So nicht:
Select * from namen where contains(*, '"*echnaflo*"')
wie finde ich den Datensatz, wenn ich nach 'echnaflo' suchen will?
Danke
I believe that * is only a wildcard at the end of a CONTAINS search term,
not at the beginning. So your query is looking for the literal string
"*echnaflo" at the start of a word. You can use LIKE as a workaround, of
course:
select *
from namen
where col1 like '%echanflo%'
or col2 like '%echanflo%'
....
This won't be efficient, so you might want to post in
microsoft.public.sqlserver.fulltext to see if someone there has a better
suggestion on how to solve your issue.
Simon