[dba-SQLServer] Formatting Numbers IN SQL

Thanks.  I was hoping to be able to do it in SQL as there are other 
manipulations to do before getting to the front end, but it looks 
like your suggestion is the only easy option.

At 17/09/2008, you wrote:
>Since SQL is a backend only, this sort of formatting is not 
>generally handled there.  Access does formatting at the table level 
>because it is also a front end and can pass that seamlessly.
>
>Just set the data type to integer if you do not want any decimals to 
>be stored.  Otherwise, set the format at the front end.
>
>Debbie
>
>-----Original Message-----
>From: David Emerson <newsgrps at dalyn.co.nz>
>Sent: Tuesday, September 16, 2008 12:19 PM
>To: dba-SQLServer at databaseadvisors.com
>Subject: [dba-SQLServer] Formatting Numbers IN SQL
>
>Since I didn't get a reply I will try another tact.
>
>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"?
>
>
>Regards
>
>David Emerson
>Dalyn Software Ltd
>Wellington, New Zealand
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com