how we pass string value in Dynemic query in Store procedure...

See more:

ASP.NET

SQL

stored-procedure

I want to generate dynemic query according to some condition,i made it on my C# page then query work well, now my condition is i want to make this same query in Store procedure,

but my problem is how are pass string value into this query,
this is my code..

ALTER PROCEDURE [dbo].[proc_JugmentSearchCount]

    @Favour  nvarchar(MAX)='Partly',
AS
BEGIN
      SET NOCOUNT ON;
      DECLARE @DynamicSQL nvarchar(max)

      SET @DynamicSQL = 'SELECT  count(jid)  FROM tblJudgements1  where scategoryname=''Judgements'''


         Set @DynamicSQL = @DynamicSQL + ' And (favour =' +@Favour+')'

      EXECUTE sp_executesql @DynamicSQL
END

the query not take the value of "@Favour" string, and if i write query like this then it work well..

SET @DynamicSQL = 'SELECT  count(jid)  FROM tblJudgements1  where scategoryname=''Judgements'''


        Set @DynamicSQL = @DynamicSQL + ' And (favour =''partly'')'

     EXECUTE sp_executesql @DynamicSQL

but in my case the value of @Favour is came at my C# page...

so what can i do... plz help.....