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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-06 : 17:05:50
|
Simon writes "in a query using full index searching
E.g.
select * from tblProducts where contains(definition, '"track*"')
this defines a prefix of track*
this will return rows with definition="track", "tracking", "tracked"
but how do I make it work on the suffix
E.g. it wont return a definition ="railtrack"
if I use the like clause I can make it work
Eg.
select * from tblProducts where definition like '%track%'
but I need to use full index search!" |
|
|
|
|
|
Full Index Searching