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 - 2000-12-07 : 21:36:34
|
Maurice writes "I have a database table that I am doing full text searching on. I am using the following stored procedure to do this:
CREATE PROCEDURE sp_FullTextSearchBasic
@keywords varchar(50)
AS
EXEC ('SELECT title FROM tblBib
WHERE CONTAINS(title, " '
+ @keywords
+ ' ")')
GO
I have included error checking in case the user enters nothing but the problem is when the user enters an ignored word, for example 'it'. What is the quickest and best way around this problem?
Thanks
Maurice" |
|
|
|
|
|
Searching a SQL database