CREATE FUNCTION  GetFractional( @Param1 decimal (18,3) )
      RETURNS decimal (18,3)
AS
BEGIN
	-- Declare the return variable here
	DECLARE  @ResultVar  Money
Declare @_Number Money
DECLARE  @R  decimal (18,3)
set @R=@Param1
set @R=  @Param1-convert(int, @R) 

 --set @ResultVar=convert(decimal(1,1),@Param1)

  Select @_Number =Round (@R,3)

if (@_Number between ( 0.1) and (0.500))
begin
set @_Number =0.500
end


if (@_Number <= 0.0)
begin
set @_Number =0
end


if (@_Number>0.500)
begin
set @_Number =1
end


return @_Number

END



















