serkan sendur 821 Postaholic Banned Featured Poster

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