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 >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com