| | |
Decimal seperator - thousand seperator when using sql server
Please support our MS SQL advertiser: Intel Parallel Studio Home
Thread Solved |
•
•
Join Date: Jan 2008
Posts: 2,052
Reputation:
Solved Threads: 118
In Turkey we use "." as thousand seperator and "," as decimal seperator. If you are working with currencies in sqlserver, and if the money columns is of type "money" then the problem occurs beause of the seperator issue since in its default mode sql server accepts "," as thousand and "." as decimal seperator. So there are two solutions to this problem; either you wont use money type and use decimal type instead in sql server or replace your "," character with "." character within your queries or stored procedures
Due to lack of freedom of speech, i no longer post on this website.
![]() |
Other Threads in the MS SQL Forum
| Thread Tools | Search this Thread |






