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 2:10 pm
#736527
what is the datatype of the field containing the decimal point?
If it's varchar you could:
declare @mynum varchar(20)
set @mynum = '10.7333'
select replace(@mynum,'.','')