Different Results with double quote

If i do the following SQL_queries:
select * from exampletable where CONTAINS(exampletable.exampletext, '
"Shure*" ')
select * from exampletable where CONTAINS(exampletable.exampletext, '
Shure* ')
The query with the double quotes returns much more result and most of them
do not contain the word shure. The query without the quotes returns the
correct rows. Whats the difference for the server?
I am using a Windows 2000 Server with SQL 2000 Server.
Thanks in andvance, Gerald.
Gerald wrote on Tue, 23 Jan 2007 14:50:01 -0800:

> If i do the following SQL_queries:
> select * from exampletable where CONTAINS(exampletable.exampletext, '
> "Shure*" ')
This is a prefix term search, which finds all words that start with the
letters Shure, for instance
Shure
Shurec
Shuretacal

> select * from exampletable where CONTAINS(exampletable.exampletext, '
> Shure* ')
The * is ignored as it only applies when double quotes are used, so only
rows with the word Shure are returned.
Dan
|||"Daniel Crichton" wrote:

> This is a prefix term search, which finds all words that start with the
> letters Shure, for instance
> Shure
> Shurec
> Shuretacal
Thx, Daniel. But in my case the query with the double quotes returns also
results, which do not contain any word starting with shure. It just returns
useless results.
thx, gerald
|||Gerald wrote on Wed, 24 Jan 2007 05:41:01 -0800:

> "Daniel Crichton" wrote:
>
> Thx, Daniel. But in my case the query with the double quotes returns also
> results, which do not contain any word starting with shure. It just
> returns useless results.
Strange. I just tested here using my own servers (both SQL 2000 and SQL
2005) with the following:
SELECT FullTitle FROM Product WHERE CONTAINS(Product.FullTitle,'"asp*"')
and
SELECT FullTitle FROM Product WHERE CONTAINS(Product.FullTitle,'asp*')
The results are as I expected - the first pulls back more titles (351
compared to 101), including ASP as a word, and other words that start wth
ASP such as ASP.NET. The second pulls back only those rows where the word
ASP occurs.
What language word breaker is your FTI using? Maybe there's some sort of
language subsitution going on. Or do you use the thesaurus?
Dan