471,873 Members | 2,034 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,873 software developers and data experts.

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 1459
"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
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.