【SQLSERVER】自定义函数：去零函数ClearZero

----去零函数 ---去除小数点后多余的零 select dbo.ClearZero('1245.3400') ---结果为1245.34 
create function [ClearZero] 
(@Number varchar(200)) 
returns varchar(200) 
as 
begin 
if @Number = '' or @Number is null ---如果为空，直接返回 
 return null 
else 
begin 
declare @PointIndex int 
set @PointIndex = charindex('.',@Number) 
if @PointIndex = 0 return @Number ---如果不是浮点数，直接返回 
if @PointIndex = len(@Number) return replace(@Number,'.','') ----数字末尾有小数点，直接删除返回 
else 
begin 
if right(@Number,1) = '0' ---递归调用，进行去零操作 
begin 
set @Number = substring(@Number,1,len(@Number) - 1) 
 return dbo.ClearZero(@Number) 
end 
else 
 return @Number 
end 
end 
 return null 
end 
GO