a stored procedure with parameter

[vcllvc]

is it possible to pass a + or - as a parameter in a stored procedure so that it can do something like below:

select price + '@PlusOrMinus' + @newprice from tblRateDetails where ID=@ID

Or I have to accomplish the task using if statement?

Thanks in advance.

 

[SQLSister]

You can do that using sdynamic SQl, but I would suggest a better way id to append a - sign onto the newprice variable if need be and pass in either a positive or negative number which will then be added to the other number.

Questions about posting. See faq183-874
Click here to help with Hurricane Relief

 

[vcllvc]

nice and clean. THANKS so much.