Currency data type

[John Rebbeck]

I'm currently using Decimal for my currency data but I noticed it has 4
decimal places (which is wrong when displaying with .ToString()). I either
need to format the data correctly when displaying it or use a data type
intended for currencies. Can anyone help me? Btw, I use SQL Server with its
money data type so they need to be compatible.

Cheers,
John

[Marc Hoeppner]

Hi,

MONEY translates to decimal or numeric anyway, can't remember which. You can
use formatting strings, here is a good page (VB though ;)

[url]http://www.aspfaqs.com/ASPscripts/PrintFAQ.asp?FAQID=181[/url]

Best regards,

Marc Höppner
NeoGeo

"John Rebbeck" <john@rebent.com> wrote in message
news:%234J5LnHTDHA.3116@TK2MSFTNGP10.phx.gbl...

> I'm currently using Decimal for my currency data but I noticed it has 4
> decimal places (which is wrong when displaying with .ToString()). I either
> need to format the data correctly when displaying it or use a data type
> intended for currencies. Can anyone help me? Btw, I use SQL Server with

its

> money data type so they need to be compatible.
>
> Cheers,
> John
>
>