July 11, 2003 at 8:54 am
Hi,
I am very new to SQL Server. There is a multilingual application we are developing. I have a question. When I am querying my database, there are numbers with decimal points. In languages like German, the decimal points are coming as comma. How can I explicitly tell the application to display the output like that. Do I need to declare something before executing the sql? Is there any commands which can execute before executing the sql(select) which will change the output according to the language?
Any help is really appreciated.
Sun
July 11, 2003 at 10:00 am
In fact this is a presentation issue that you should tackle in your application, not at the DB level. If you output a number and you state at OS (Windows) level the correct formatting, it should be correct.
But, there always is a way ...
You can use STR to convert your number to a string, and then REPLACE to replace the dot by a comma.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply