Check:
DECLARE @Amount varchar(20) = '82,490.00';
SELECT CONVERT(varchar, CONVERT(money, @Amount), 1),
REPLACE(CONVERT(varchar, CONVERT(money, @Amount), 1),',',SPACE(0));
-- 82,490.00 82490.00
Kalman Toth Database & OLAP Architect SQL Server 2014 Database Design
New Book / Kindle: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2014
No comments:
Post a Comment