Use the acos instead of that return float so implicit conversion can not be a question.

declare @l decimal(38,2)

SET @l = 24.35

-----Right Result---------

if (@l - convert(int,@l)) = 0

begin

SELECT

FLOOR(@l)

end

else

begin

SELECT

@l

end

------------Wrong Result-----------

SELECT

CASE

WHEN @l -...