How to use SOUNDEX in Full Text Search (SQL2000) ?

Hi there

I have this query in a stored procedure

SELECT *
FROM Product
WHERE FREETEXT (*, @.SearchString )

When I run the query with the @.SearchString = 'hoover' it return values but if I spelt it wrong (eg: hover) I have no value return

My question is, How can I use the SOUNDEX in a full text search

Regards

Sorry to bring this one back up but to this day I couldn't find an answer to my question. Anyone ?

|||

Hi.

select * from Product where

soundex(fieldname)=soundex(@.SearchString)

|||Thanks but it's not using Full Text search this way|||

Sleb:

Thanks but it's not using Full Text search this way

Hi Friend , but this is the possibility of SOUNDEX Function.may be you need other method.

to see th possibility of SOUNDEX http://msdn2.microsoft.com/en-us/library/aa259235(SQL.80).aspx

to see how SOUNDEX work :http://www.tek-tips.com/faqs.cfm?fid=4110

Regards..

|||

Thanks Lovely,

You maybe right, I think I didn't ask the question in a good way.

What I need to know is if it's is possible to use the SOUNDEX function in a Full Text Search

|||

yeah it consider one of the method use in Full Text . TheFull Textallows you to define the search method and modifiers that you want to use as well as the query terms, for example:Sounds Like,Synonyms Of ,Word Begins With,Word Ends With, Word Contain.... andSounds Like use SOUNDEX algorithm.

Regards.