Formatting currency in select statements.

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

SQL Server Development (2000)

Formatting currency in select statements.

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-12 : 09:03:26

Sue writes "I am trying to format a money datatype to include commas when a results set is returned.

In oracle, the following statement:

select '$'||to_char(amount_billed, '99G999D00') from Cust_orders;

Would return the following results set:

$40,000.44
$ 5,000.00
$    99.23

Is there a sql server version?"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources