Search This Blog

Friday, February 4, 2011

Convert 100000 to 100,000

Check this out;

--with .00
Select CONVERT(varchar(20), CAST(12342 AS money),1)

--without .00
SELECT REVERSE(SUBSTRING(REVERSE(CONVERT(varchar(20), CAST(1234266666 AS money),1)), 4, 20))

No comments:

Post a Comment