bank5
03-21-2007, 09:16 AM
I am performing a query on a users that uses the contains predicate:
SELECT * FROM table_Users where
CONTAINS(Last_Name, ''' + @LastName + ''*')
This seems to work fine for all users except for one user whose last name is See Jones. When I search for "See Jones" no results are found. However, if I change the last name to Se Jones, and search for "Se Jones" the query finds the user. Also, if I change the name to Seee Jones and search for "Seee Jones" it will find the user.
I think what's happening is that the Contains predicate considers see to be a noise word. I'm not sure why it doesn't return "See Jones" though. Any ideas on how this can be fixed?
SELECT * FROM table_Users where
CONTAINS(Last_Name, ''' + @LastName + ''*')
This seems to work fine for all users except for one user whose last name is See Jones. When I search for "See Jones" no results are found. However, if I change the last name to Se Jones, and search for "Se Jones" the query finds the user. Also, if I change the name to Seee Jones and search for "Seee Jones" it will find the user.
I think what's happening is that the Contains predicate considers see to be a noise word. I'm not sure why it doesn't return "See Jones" though. Any ideas on how this can be fixed?