Viewing 2 posts - 1 through 2 (of 2 total)
SELECT val
,STUFF(val, CHARINDEX('%', val)-1, 1, '') AS truncval
,LTRIM(CAST(ROUND(CAST(REPLACE(val, '%', '') AS DECIMAL(10,2)),1,1) AS DECIMAL(10,1))) + '%' AS truncval2
,LTRIM(CONVERT(DECIMAL(10,1),...
September 12, 2014 at 12:38 pm
#1745175
FROM (VALUES ('99.87%'), ('99.96%'), ('8.67%')) AS sample(val)
September 12, 2014 at 10:55 am
#1745151