Lol, I was half way there, Write a Stored Procedure utilizing a "function".

CREATE FUNCTION ODD_or_Even

(@Digit nvarchar(3))

RETURNS varchar(4)

AS BEGIN declare @Return varchar(30)

select @return = CASE WHEN

CAST(@Digit as decimal)/CAST(2 AS decimal)NOT LIKE '%.0%' THEN 'Odd' ELSE 'Even' END

return

@return

end

CREATE PROCEDURE AmIOddorEven

@Digit nvarchar (3) = '3'

AS

SELECT dbo.ODD_or_Even(@Digit)