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 |
|
sparrow37
Posting Yak Master
148 Posts |
 Posted - 2011-07-01 : 15:01:37
|
| have a view with full index on fullname. when i runSELECT * FROM vwPersonSearchit returns rowswhen I run:SELECT * FROM vwPersonSearch WHERE [Full name] ='Mark RUSH')It returns one rowwhen I run:SELECT * FROM vwPersonSearch WHERE contains([Full name],'"Mark*" AND "RUSH*"')It doesn't return any row. Why so ? |
|
|
|
|
|
Full text search issue in stored procedure