Insert using numeric format in different language

[bessebo]

I am trying to do an insert into a table where the language is Dutch. In this language a comma is used for a decimal point. How can I insert using the comma as a decimal point without SQL thinking it is truly a comma? I tried using the Set Language Dutch command but I think this only applies to dates. Thanks in advance...

Bessebo

 

[tlbroadbent]

SQL Server only accepts a comma as a delimiter between numbers and not as a decimal separator. You must follow the SQL Server syntax or formatting when passing data to SQL. There is no workaround for this. Your application must send SQL Server data in the form and format expected by SQL Server. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.