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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL Server - Regional settings

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-01-23 : 09:37:02
Sachin writes "I have a VB app which uses ADO to talk to SQL Server. When I construct a query and fire it on SQL Server, it gives me a error for numeric fields whenever I run on a german or french client, bcoz the ',' is use instead of '.' in these locales. How can I make sql server accept these SQL statements, or is it a rule (if yes where is it documented) that in numbers in SQL statement we can only have '.' for decimal seperator.

Regards

Sachin"
   

- Advertisement -