Home Forums SQL Server 2005 T-SQL (SS2K5) Remove Decimals Without Rounding RE: Remove Decimals Without Rounding
chan_dwr
SSC Rookie
Points: 49
More actions
September 29, 2007 at 1:25 pm
#737410
DECLARE @MYDECVAR DECIMAL
DECLARE @MYINTVAR INT
SET @MYDECVAR = 100.123
SET @MYINTVAR = CAST(@MYDECVAR AS INT)
SELECT @MYINTVAR
CHEERS 🙂
CHANDRA