Home Forums SQL Server 7,2000 T-SQL Count Decimal Places RE: Count Decimal Places
Ken McKelvey
SSCoach
Points: 18755
More actions
October 10, 2006 at 9:25 am
#665031
DECLARE @D DECIMAL(18,9)
,@S VARCHAR(20)
,@R VARCHAR(20)
SET @D = 0.8333
SET @S = CAST(@D AS VARCHAR(20))
SET @r = REVERSE(SUBSTRING(@S, CHARINDEX('.', @S) + 1, 20))
SELECT LEN(SUBSTRING(@R, PATINDEX('%[1-9]%', @r), 20))