Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lleemon
Starting Member
24 Posts |
 Posted - 2011-04-09 : 17:48:05
|
| I just setup a full-text search on one field 'product_name' and it seems to find results if a full word is found. For example,'large apple pie' is one field and if found if I do:select * from product where contains(PRODUCT_NAME, '"large" OR "pie"')but isn't found if I do:DECLARE @SearchPhrase varchar(50)SET @SearchPhrase = '"*arg*" OR "*ppl*"'select * from product where contains(PRODUCT_NAME, @SearchPhrase)What's the best way to search if my input is two or three words and find all accurances? |
|
|
|
|
|
full-text search