[MS-SQL] 문자열 금액표시
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)
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)
