CREATE FUNCTION uf_get (@var1 decimal(9,2))
returns varchar(10)
as
begin
DECLARE @rtn varchar(10),@zs varchar(10),@xs varchar(10)
DECLARE @i int
set @zs = rtrim(ltrim(substring(cast(@var1 as varchar(10)),1,PATINDEX('%.%',cast(1.00 as varchar(10))) - 1)))
set @xs = rtrim(ltrim(substring(cast(@var1 as varchar(10)),PATINDEX('%.%',cast(1.00 as varchar(10))),LEN (cast(1.00 as varchar(10))) - PATINDEX('%.%',cast(1.00 as varchar(10))) + 1)))
set @i = len(@xs)
while @i > 1
begin
if substring(@xs,@i,1) = '0'
begin
set @xs = STUFF(@xs,@i,1,'')
end
else
begin
break
end
set @i = @i - 1
end
set @zs = rtrim(ltrim(@zs))
set @xs = rtrim(ltrim(@xs))
if @xs = '.'
begin
set @rtn = @zs
end
else
begin
set @rtn = @zs + @xs
end
return(@rtn)
end