Home Forums SQL Server 2005 T-SQL (SS2K5) Remove Decimals Without Rounding RE: Remove Decimals Without Rounding
Janet Keith-489067
Ten Centuries
Points: 1052
More actions
September 26, 2007 at 1:19 pm
#736511
declare @mynum decimal(10,2)
declare @mynum1 int
set @mynum = 10.73
select @mynum1 = @mynum * 100
print @mynum
print @mynum1
or
select cast(@mynum * 100 as int)