Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Format Numbers

Author  Topic  empire Starting Member 40 Posts Posted - 2001-10-07 : 11:55:13 Hello, Does anyone have any simple means to format a money/interger data type on the way out of a SQL statement. Data => 1000000 Out => 1,000,000 Data => 2000.00 Out => 2,000 Thanks Programmers are simple devices, put caffeine in, and get code out.