Sunday, March 11, 2012

Currency

Hello I am a newbe to sql and i am shure my problem is simple but hope somone can help.
My Total comes out like $20.00 and i want it to come out like 20.00
Simple but frustraiting
Any help apprieciated
ColinThis is a formatting issue, and thus does not fall under the scope of the SQL Engine. What application/interface are you using to display the value, and what datatype are you using?|||Thanks for your reply

The data type is set to money and its a web site built with Dreamweaver and it outputs in explorer if thats what you mean.

Thanks again

Colin|||The SQL Money data type just defines how the data is stored in SQL Server. Four significant digits held to the right of the decimal point. It has nothing to do with how it is formatted.

You need to check Dream Weaver's help file for assistance, though Dream Weaver may just check your system defaults.|||Thanks again I will do that, but I think I have been here befor.

Best regards,

Colin

No comments:

Post a Comment