Currency conversion

microsoft.public.sqlserver.programming

30 Jun 2006 7:04 AM

Ivan Debono

Hi all,

I have an application based in Germany where the currency is the following
format: #.###,00

Users enter values in the above format but SQL Server requires the standard
format: #,###.00

Is there a way that I can tell SQL Server to convert formats automatically
or should I do the conversion in my code?

Regards,
Ivan

30 Jun 2006 10:22 AM

amish

Ivan Debono wrote:

> Hi all,
>
> I have an application based in Germany where the currency is the following
> format: #.###,00
>
> Users enter values in the above format but SQL Server requires the standard
> format: #,###.00
>
> Is there a way that I can tell SQL Server to convert formats automatically
> or should I do the conversion in my code?
>
> Regards,
> Ivan

Applications can do better formating of data than SQL Server.

Regards
Amish Shah