I have data (in SQL Server 2005 SP2) that looks like:
ID, Name
1, elbonia university of medical science
2, elb univ med sci
3, elbonia university, med sci
4, elbonia has universities, blah blah blah medium sized scientists
And a query that looks like:
SELECT ID FROM tbl WHERE CONTAINS(Name, '"elb univ med sci*"')
I want it to get 1-3 and not 4, but it just gets 2 and 3. I think the noise word 'of' is throwing if off but if I try:
SELECT ID FROM tbl WHERE CONTAINS(Name, '"elb univ of med sci*"')
I get nothing! WTF Does a noise word break prefix searches The only message is "(0 row(s) affected)"
SELECT ID FROM tbl WHERE CONTAINS(Name, '"elbonia university of medical science"')
returns 1 but add the * for stemming:
SELECT ID FROM tbl WHERE CONTAINS(Name, '"elbonia university of medical science*"')
and it also returns nothing.
Thanks for looking! -Andrew