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 |
|
fizgig
Starting Member
34 Posts |
 Posted - 2002-01-23 : 05:19:52
|
| I am building a simpel search interface for my forum software. I want to search on all words in the search string such as "pizza garlic". That's not difficult, i already know how to do this. My problems start when a user enters things like "o'neill clothing" or a querystring that only contains common words that are ignored by SQL SERVERI've been searching the internet for some standard code, but couldn't find good code that interacts with full text indexing. Anyone got code or some links for me 2 check out? |
|
|
spock
Starting Member
35 Posts |
Posted - 2002-01-23 : 09:23:50
|
| I am not clear what your exact requirements are.can u be more clear ?btw this would solve one of your problems i hopeselect * from tablename where colname like 'o''neil%'hthkaushik |
 |
|
|
fizgig
Starting Member
34 Posts |
Posted - 2002-01-23 : 09:26:01
|
| I need a script that can always create a valid CONTAINS query from the searchquery a user enters. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-01-23 : 10:09:44
|
| I'm assuming you're using full-text indexing. If not, check http://www.sqlteam.com/item.asp?ItemID=1876===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
fizgig
Starting Member
34 Posts |
Posted - 2002-01-23 : 11:48:22
|
| Yupz, i use full text indexing |
|
|
|
|
|
|
A simpel search interface