469,087 Members | 1,267 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,087 developers. It's quick & easy.

Is a fulltext serarch for *whatever possible?

Using CONTAINS, we can search for "never*" and we will find "nevertheless".
However, I would like to do the inverse: "*less" should also find
"nevertheless". Strangely, I can't find that in the doc and it does not seem
to work.

Am I getting something wrong? Or is this really not possible?

Thanks a lot for your hints,
Matthias Haldimann

PS: This "*whatever" search may not look THAT useful in English, but it is
very important for searches within German nouns.
Jul 20 '05 #1
1 1417
"Matthias HALDIMANN" <ma****************@epfl.ch> wrote in message news:<3f********@epflnews.epfl.ch>...
Using CONTAINS, we can search for "never*" and we will find "nevertheless".
However, I would like to do the inverse: "*less" should also find
"nevertheless". Strangely, I can't find that in the doc and it does not seem
to work.

Am I getting something wrong? Or is this really not possible?

Thanks a lot for your hints,
Matthias Haldimann

PS: This "*whatever" search may not look THAT useful in English, but it is
very important for searches within German nouns.


You might want to post this question to
microsoft.public.sqlserver.fulltext, but the documentation for
CONTAINS indicates that only searches on prefixes are possible.

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Henry Hank | last post: by
reply views Thread by Matt W | last post: by
8 posts views Thread by Radim B | last post: by
reply views Thread by Phil Powell | last post: by
reply views Thread by Alex Glass | last post: by
reply views Thread by Robert Oschler | last post: by
1 post views Thread by Robert Oschler | last post: by
reply views Thread by Roger Felstree | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.