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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 full text handling input

Author  Topic 

rico_bano
Starting Member

35 Posts

Posted - 2007-04-16 : 10:10:54
Can anyone tell me or point me in the correct direction on how to handle user input for full text searches.

im particularly interested in how users should enter the text to search on

e.g

abcde = find all records containing abcde
abcde fghij = find all all records that contain either abcde or fghij
abcde + fghij = find all records that contain both abcde and fghij
"abcde fghij" = find all records that contain abcde fghij (as a sentence).

Can anyone tell me if this is correct.

Also when using full text search do i have to remove words such as "and" and "or" etc etc

Your help is greatley appreciated

rico_bano
Starting Member

35 Posts

Posted - 2007-04-17 : 04:22:20
someone must have some ideas
Go to Top of Page
   

- Advertisement -