• Thank You Adam,

    Do you mean like:

    create procedure spFT

    @term nvarchar (250),

    @position int,

    @value_per_month int

    as

    Begin

    select [term],[position],[value_per_month]

    from [dbo].[XXXX]

    where [term]=@term and ([position]=@position) >=0

    and [value_per_month]=@value_per_month >=0

    End