Thanks all for your input. 

The SQL Server respected the Regional Settings Decimal separator when I did my testing.  When I changed to period, I could enter the float values...

I tried add SET ANSI_WARNINGS OFF to the proc and still the get the warning

-2147217871 [Microsoft][ODBC SQL Server Driver][SQL Server]Caution: Changing any part of an object name could break scripts...

Sushila,

Outputting data format is not the problem.

Here is an Example.  2 people login to the database.  On the form, there is a float field, that displays 56,45 for a German...

Thanks all for the replies.  Here is what I am looking for.

We have a database that needs to be supported for multiple languages.  Based on the Client locale, the decimal...

Like, how do I get if the separator is . or ,

sysforeignkeys SQL system table has the info.  But it only the id's of the objects.  You will have to build the statement yourself.