Posted by: sanjnep71 June 12, 2006
Login in to Rate this Post:
0
?
--Here is the code for plus and minus.
--You can run it on sql server query analyzer
CREATE FUNCTION Calculator
(@var1 INT,
@var2 INT,
@op VARCHAR(1))
RETURNS INT
AS
BEGIN
DECLARE
@result INT
IF (@op = '+')
SELECT @result = @var1 + @var2
IF (@op = '-')
SELECT @result = @var1 - @var2
RETURN (@result)
END
SELECT dbo.Calculator(10,2,'-')