Anyone Here Familiar With Stored Procedures?

Hi there! I would like to return a default status value (-101) if the -100 and 200 conditions are not met. Is there any way I can go about it?








ALTER PROCEDURE spServiceFormGet (@TicketNo int, @Name char(50))


AS





IF NOT EXISTS (SELECT SolutionID FROM ServiceForm where SolutionID = @TicketNo)


RETURN -100





IF EXISTS (SELECT SolutionID, SolvedBy FROM ServiceForm


WHERE SolutionID = @TicketNo AND SolvedBy LIKE @Name


OR SolutionID = @TicketNo AND SolvedBy IS NULL)


SELECT * FROM serviceform where SolutionID=@TicketNo


RETURN 200





ELSE <--- something like that


RETURN -101 <--- something like that











Thanks,


-Gabian-