I have created this blog to place some of important things on it for my personal use and also to help others. Now a days I am doing job as Software Engineer in a company. I have completed my graduation in Computer Science from University of Sindh, Jamshoro, Pakistan.
Saturday, May 1, 2010
FORMATTING NUMBERS IN SQL
To format numbers in sql queries in SQL SERVER 2005, use the following command
Select Convert(nvarchar,cast(123123323 as money),1)
This will convert the following number 123123323 to 123,123,323.00