select Replace(convert(varchar(50), cast(120000 as money), 1), '.00', ''), Left(convert(varchar(50), cast(120000 as money), 1), Len(convert(varchar(50), cast(120000 as money), 1)) - 3)
select Replace(convert(varchar(50), cast(120000 as money), 1), '.00', ''), Left(convert(varchar(50), cast(120000 as money), 1), Len(convert(varchar(50), cast(120000 as money), 1)) - 3)