Hello

I want to write stored procedure,which will use FormsOF Inflectional,

BUT I am getting error,actually I dont know how to pass parameter in the
Inflectional query.

here it goes....
USE [charlotte]
GO
/****** Object: StoredProcedure [dbo].[sp_AdvanceSearch] Script Date:
08/11/2008 12:46:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[sp_AdvanceSearch]

@Text VARCHAR(300)

As
Begin
Set nocount on;

Select s.SystemElementID,DocumentID, SETitleText as "Title",ElementText as
"SearchElement"

FROM TextElement t,SystemElement s,TOCMap tp,TableOfContents tc

Where t.SystemElementID=s.SystemElementID AND Freetext(ElementText,'FORMSOF
(INFLECTIONAL,'+@Test+')') AND s.SystemElementID=tp.SystemElementID AND tp.
TableOfContentsID=tc.TableOfContentsID

END

If I am using '+' before and after @text,then also it is giving me error,

Please help,I have been trying to do this from long time.

Thank You