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 |
wilang
Starting Member
12 Posts |
Posted - 2009-08-05 : 00:15:57
|
hi all,it is possible in query sql server to show some integer( 10000000) become like this 1.000.000 (money format)??W |
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-08-05 : 00:25:23
|
is this u wantdeclare @i intselect @i = 10000000select CONVERT( VARCHAR(50),convert(money,@i),1) |
|
|
wilang
Starting Member
12 Posts |
Posted - 2009-08-05 : 00:41:15
|
i see, so first we convert to money and next we convert to varchar(50) with argument 1.Thank you bklr for your answer!^_^W |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-08-05 : 00:43:31
|
welcome |
|
|
|
|
|