What are you trying to accomplish with the >= comparisons here:

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

and [value_per_month]=@value_per_month >0

?

if you're trying to validate that the values passed to @position and @value_per_month are both greater than zero, you would have to do something like this:

CREATE PROC spFT

@term nvarchar (250),

@position int,

@value_per_month int

AS

BEGIN

IF @value_per_month>0 AND @position>0

BEGIN

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

from [dbo].[XXXX]

where [term]=@term

and [value_per_month]=@value_per_month

and [position] = @position

END

ELSE

PRINT 'oops!' -- trap errors here.

END

If you're trying to change the comparison operators in your stored procedure so that you can use any of {=,>=,<=} you would have to either create another branch or use dynamic SQL.