【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