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))
Showing posts with label Numeric Conversion. Show all posts
Showing posts with label Numeric Conversion. Show all posts
Friday, February 4, 2011
Subscribe to:
Posts (Atom)