best way to store currency amounts in MS SQL

[TechBoyJK]

I see that they have a money variable, but im curious if it will work with all currencies...

off to google I go!

I need to store money values for everythign from YEN, rupees, to the dollar... everything really, so I need a variable store that will accomodate all...

 

[Modeps]

How about a float?

 

[TechBoyJK]

Originally posted by: Modeps
How about a float?

well, there will be decimal entries... so that may be the way I go... im still looking around for "best practice" knowledge...

 

[WannaFly]

there is a money data type in MSSQL, use it. It properly handles rounding, etc.

edit: i didnt read your whole post. Im not sure if it will work with other currencies. If it doesnt, decimal is probably best.

 

[TechBoyJK]

Originally posted by: WannaFly
there is a money data type in MSSQL, use it. It properly handles rounding, etc.

edit: i didnt read your whole post. Im not sure if it will work with other currencies. If it doesnt, decimal is probably best.

thanks... i was aware of the money type, but my concern was functionality with other currencies... im probably going with decimal.