DECLARE @decimal decimal(6, 6)
SET @decimal = 0.6667
DECLARE @decimal2 decimal(6,2)
SET @decimal2 = @decimal
PRINT @decimal2
DECLARE @vchar_decimal varchar(4)
SET @vchar_decimal = CAST(@decimal as varchar(10))
PRINT @vchar_decimal
DECLARE @char_decimal varchar(MAX)
DECLARE @decimal_position int
DECLARE @decimal_output varchar(50)
SET @char_decimal = CAST(@decimal as varchar(MAX))
SET @decimal_position = CHARINDEX('.', @char_decimal)
SET @decimal_output = SUBSTRING(@char_decimal, 1, (@decimal_position + 2))
PRINT @decimal_output
Hope this helps,
-Artificer GM