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 |
|
msd1357
Starting Member
3 Posts |
 Posted - 2007-10-17 : 10:06:08
|
| Hi,How can I select a big numeric value that separated with comma?Like this:SELECT myInt from Table1I want that return value would be like this:----------------176,26273,632283,873,323----------------regards.. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-10-17 : 10:10:55
|
why don't you do the formatting of numbers your front end ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-17 : 10:11:18
|
Look at "CAST & CONVERT" in Books Online, or let the front-end application format the value.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-17 : 10:32:00
|
quote:
Originally posted by msd1357
Hi,How can I select a big numeric value that separated with comma?Like this:SELECT myInt from Table1I want that return value would be like this:----------------176,26273,632283,873,323----------------regards..
Where do you want to show data?If you use front end application, use format function thereEx in VB6Format(Rs("col"),"###,###")MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|
|
Thousand separator?