我的数据是
max Turbine Servicing Time(s)
min Turbine Servicing Time(s)
Turbine Uptime(s)
max Turbine Uptime(s)
min Turbine Uptime(s)
Environment condition available time(s)
max Environment condition available time(s)
min Environment condition available time(s)
怎么去掉(s)
显示到表中
max Turbine Servicing Time
min Turbine Servicing Time
------解决思路----------------------
REPLACE([字段],'(s)','')
类似这样
------解决思路----------------------
select left([字段],len([字段])-3)