sql语句,decimal字段,去除小数点后多余0

---

前言

数据库是decimal字段的,页面往往需要显示有效的字符,那么后面多于的0,就很扎眼了,后台做转换,浪费资源,sql中直接处理!

---

一、直接上效果图

转换成去小数点后0的加上单位 字符串
转换成去小数点后0的字符串

页面显示

二、数据库decimal字段,去除小数点后0

1.sql语句如下

select HAA014, 

(case when cast(HAA014 as float) > cast(cast(HAA014 as float) as INT) then cast(HAA014 as float) 
else cast(cast(HAA014 as float) as int)
end
) as HAA014C 

from DCSHAA

select HAA014, 
(case when cast(HAA014 as float) > cast(cast(HAA014 as float) as INT) then cast(cast(HAA014 as float) as varchar)
else  cast(cast(cast(HAA014 as float) as int) as varchar)
end)+'('+HAA005+')' as HAA014C 
from DCSHAA

使用时,替换case判断部分HAA014(需要数字转换的字段),HAA005(单位字段)为你的目标字段即可