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 |
|
johnstern
Yak Posting Veteran
67 Posts |
 Posted - 2007-10-22 : 10:16:26
|
| how can I format field so commas will indicate thousandsI have 1450090 I would like it to display as 1,450,090 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-10-22 : 10:19:12
|
| do this in your front end app. formatting is much simpler there than on the sql server.if you must do it on sql server look up Convert function and it's options for money formatting_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-22 : 10:45:10
|
Why is this, that so many questions of exact same nature pops ut within minutes from eachother?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-10-22 : 11:58:16
|
maybe it is international do-your-number-formating-in-sql day ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-23 : 01:40:54
|
quote:
Originally posted by khtan
maybe it is international do-your-number-formating-in-sql day ?
KH[spoiler]Time is always against us[/spoiler]
Then tell them that every day is do-your-number-formating-in-front-end day  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
format field so commas will indicate thousands