欄位為id，存取的值有1,1.0,1.09。。。。。現在統一取出結果為1.0 select left(cast(id as DECIMAL(18,6) ) , charindex('.',cast(id as DECIMAL(18,6) )) + 1) ...
欄位為id，存取的值有1,1.0,1.09。。。。。現在統一取出結果為1.0
select left(cast(id as DECIMAL(18,6) ) , charindex('.',cast(id as DECIMAL(18,6) )) + 1)
