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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-16 : 08:34:28
|
| wang writes "How to display float data w/ comma separators in T-SQL? for example, 2389.09 => 2,389.09; 12345.67 => 12,345.67" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-16 : 08:40:32
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=16837 |
 |
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2002-09-16 : 08:41:54
|
| you need to convert it to money ... then convert it to varchar with a value of 2 for the #,##0.#0 format SELECT CONVERT(VARCHAR, CAST(123456.12 AS MONEY), 1) should do it for you.Edited by - onamuji on 09/16/2002 08:42:43 |
|
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-09-16 : 09:08:39
|
| Kamikaze found target, aiming... |
|
|
|
|
|
|
comma separators