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)