[dba-SQLServer] Formatting Numbers IN SQL

David Emerson newsgrps at dalyn.co.nz
Tue Sep 16 13:03:59 CDT 2008

Sorry about the confusion - it is money type (12345.00)

At 17/09/2008, you wrote:

> > There doesn't seem to be an SQL equivalent to the Access
> > Format(12345,"#,##0").  What is the simplest way of taking a number
> > like 12345.00 and converting it to a varchar "12,345"?
>====First, is it 12345 or 12345.00? Or, could it be either?
>Susan H.
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list