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 |
|
timgaunt
Posting Yak Master
115 Posts |
 Posted - 2005-07-19 : 08:01:10
|
| Hi,I've only recently had the opportunity to start playing with FTS after getting our own dedicated server with a shiney new installation of SQL Server 2000 on it however I've now got a litle stuck:I've got a products table, one of the products has the word "tiredness" in it, I thought that if I did a FTS on "tired" the record would be returned, but no matter what I've tried I've been unable to return the record (I've tried FREETEXTTABLE, CONTAINSTABLE, CONTAINS and FORMSOF(INFLECTIONAL, tired) with CONTAINS)Can anyone point me in the right direction? Incase its of use I've included my current SQL below.Cheers.Tim--- TSQL ---DECLARE @Search nvarchar(255)SET @Search = 'tired'SELECT Rank, ProductID, ModelNameFROM CMRC_Products, FREETEXTTABLE(CMRC_Products, *, @Search) searchTableWHERE [KEY] = CMRC_Products.ProductIDORDER BY Rank DESC |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-07-19 : 09:08:43
|
| Select <list> from CMRC_Products where modelname like '%' + @Search + '%'ugly and hates your indexes, but should work.*need more coffee*SELECT * FROM Users WHERE CLUE > 0(0 row(s) affected) |
 |
|
|
timgaunt
Posting Yak Master
115 Posts |
Posted - 2005-07-19 : 09:27:44
|
| Hi Don,Thanks for that but I wanted to steer away from LIKE, are there any other alternatives?Tim |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-07-20 : 11:34:45
|
| I would think that LIKE would be just as bad as FREETEXT and company...Only thing i can suggest is try it and see what kind of performance you get.*need more coffee*SELECT * FROM Users WHERE CLUE > 0(0 row(s) affected) |
|
|
|
|
|
|
|
|
Free Text Query