怎么将numeric转换成字符串，而且要去除小数点后不必要的0
比如100.0000转换成"100",100.1200则转换成"100.12"
------解决方案--------------------
- SQL code
Create function F_Num(@Num numeric(18,4))returns varchar(20)asbegindeclare @Str varchar(20)set @Str=RTRIM(@Num)set @Str=left(@Str,len(@Str)-PATINDEX('%[^0]%',REVERSE(@Str))+1)return(case when right(@Str,1)='.' then left(@Str,len(@Str)-1) else @Str end)endgodeclare @T table (ID numeric(18,4))insert @T select 100insert @T select 100.12select dbo.F_Num(ID),ID from @T