Thursday, March 26, 2015

REPLACE statement removing commas from a money convert... I do NOT want it to do this

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