Hi, I need to search a product catalog for an online store, users must be
able to search for kitchens with "4" burners, but I get this error : "A
clause of the query contained only ignored words", below is the code for
stored procedure I'm using. Before I send the "@SearchTerms" parameter, on
the client side (asp.net/vb.net) I parse the users input and concatenate
each word with an "AND", so if the user searches for "4 burner GE" y convert
this to "4 AND burner AND GE", I know the digit "4" is a noise word, and
I've seen post where people have just edit the noise word files, but I'm on
a shared hosting plan so I don't have access to them. Any ideas?

Regards,

Pablo Tola
pablo at imaget dot com

CREATE PROCEDURE SearchProducts (
@SearchTerms varchar(500)
)
AS
SELECT
[p].[ProductId],
[p].[CategoryId],
[p].[BrandId],
[p].[Code],
[p].[ManufacturerCode],
[p].[Name],
[p].[Description],
[p].[Characteristics],
[p].[Keywords],
[p].[Image],
[p].[Price1],
[p].[Price2],
[p].[Price3],
[p].[IsDisplayedInCatalog],
[p].[IsInOutlet],
[p].[IsCalculatedForGift],
[p].[GiftRangeId],
[p].[StatusId],
KEY_TBL.RANK
FROM
CONTAINSTABLE ([dbo].[Products],*,@SearchTerms) KEY_TBL
JOIN [dbo].[Products] p ON [KEY_TBL].[KEY] = [p].[ProductId]
Order By
KEY_TBL.RANK DESC

GO