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.
| Author |
Topic |
|
werhardt
Constraint Violating Yak Guru
270 Posts |
 Posted - 2008-02-12 : 10:17:14
|
| Hi,The field below I need to convert to a dollar amount. Can someone help me please?clm_tchg (decimal(10,2), null)Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-12 : 10:18:21
|
| You can do it efficiently in your front end application.what front end you are using? |
 |
|
|
werhardt
Constraint Violating Yak Guru
270 Posts |
Posted - 2008-02-12 : 10:23:41
|
I am sorry but I don't know what that is. I ususally format my field in Microsoft Visual Studio, but I thought I would do it in my SQL statment. I always do my dates like that.....CONVERT(CHAR(10), CLM_6A, 110).quote:
Originally posted by visakh16
You can do it efficiently in your front end application.what front end you are using?
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-12 : 10:47:10
|
| Yup. thats exactly what i told. You can do this effitiently using Visual Studio. Search for currency formatting functions in C# and VB.NET.refer this too:-http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=181 |
|
|
|
werhardt
Constraint Violating Yak Guru
270 Posts |
Posted - 2008-02-12 : 10:59:04
|
Thanks for your help. :)quote:
Originally posted by visakh16
Yup. thats exactly what i told. You can do this effitiently using Visual Studio. Search for currency formatting functions in C# and VB.NET.refer this too:-http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=181
|
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2008-02-12 : 13:04:44
|
quote:
Originally posted by werhardtI always do my dates like that.....CONVERT(CHAR(10), CLM_6A, 110).
Really, really bad idea, do all of your formatting at your client in .NET.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
|
|
|
Converting from Decimal to Currency