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 |
|
SCHEMA
Posting Yak Master
192 Posts |
 Posted - 2009-09-13 : 15:28:45
|
| Why Full-text doesn't support wildcard search? LikeI have column with value:AAAAAATESTAAAAAAAIf I want to search with regular like operators I get results.Select * from Table Where column like '%Test%'But doesn't work with Full-Text search.Select * from Table Where Contains(Column, ' "*Test*" ')Anyone knows why it doesn't work? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-09-13 : 16:33:42
|
| Because it performs a different task than LIKE, and there's no reason for it to duplicate it when LIKE would suffice. |
 |
|
|
SCHEMA
Posting Yak Master
192 Posts |
Posted - 2009-09-13 : 16:42:50
|
| The reason we thought to use Full-text indexing is performance reason which takes advantages of indexes. But just wondering why with full-text search I can't accomplish LIKE operations. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-09-13 : 17:44:58
|
| You should re-read Books Online about full-text indexing and searching to see if it does what you're looking for. |
|
|
|
|
|
|
Big Issue with Full-Text Search in SQL 2005