Newbie question about formatting the money data type. 
Author Message
 Newbie question about formatting the money data type.
Dear all,

How can I format the money in SQL Server 2000?
For example, 1234567.0 becomes 1,234,567.0

Thanks.

Terence



Sat, 11 Feb 2006 05:00:45 GMT
 Newbie question about formatting the money data type.

Sorry for really silly question. This can be done by using CONVERT() like
this:

SELECT CONVERT(VARCHAR(30),CAST(1234567.0 AS MONEY),1)


Quote:
> Dear all,

> How can I format the money in SQL Server 2000?
> For example, 1234567.0 becomes 1,234,567.0

> Thanks.

> Terence



Sat, 11 Feb 2006 05:13:13 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Format money data type.

2. help: money data type formatting on output

3. Disallowed implicit conversion from data type nvarchar to data type money

4. convert a money type to a format char type

5. Money data type question

6. Data field type MONEY question.

7. newbie,How to Format DATA Type?

8. Money field type same as Currency data type??

9. Formatting money types for output

10. How to convert a money type to a format char

11. Data in Excel format TYPE XLS Question

12. Easy data types question - free format text


 
Powered by phpBB® Forum Software