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 - 2006-12-14 : 08:00:40
|
| Oren Levy writes "Hi AllI’m trying to write a SQL statement for a web search engine, it should do the following:Break down the search string into individual words (for example: “500 MHz microprocessor USB”) and do a Full Text Search on a catalogue for each individual word and sort it by the rank.I’m assuming it should also take into consideration reserved words and signs.Any ideas where to start or if you can help with the SQL statement itself it would be very very very helpful.Thank you very much everyone.This site rules.Oren Levy" |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-14 : 14:33:34
|
| See Full-Text Indexes in Books Online. |
 |
|
|
|
|
|
SQL Search Engine