Home Forums SQL Server 2008 T-SQL (SS2K8) Need Alternate Solution RE: Need Alternate Solution
sqlbi.vvamsi
Ten Centuries
Points: 1194
More actions
January 22, 2013 at 12:45 pm
#1579805
this should suffice
declare @mn money=-1000000
select replace(CONVERT(varchar(50),@mn,1),'.00','') as mn