Hi,
Im having trouble with the money data type, for instance I have a column that calculates a price but it will output the price as 470.2 instead of 470.20 which is how I want it displayed on a web page.
Anyone know how to automatically insert a zero on the end of the price?
THanksNoone knows how to insert zeros on the end of numbers??|||I'm gettin '470.2000'
from this simple query I ran from query analyser
declare @.dollar as money
set @.dollar=470.2
select @.dollar
I can't understand why your only getting 470.2. Maybe you can write your calculation query for us to figure?|||I figured it out but thanks anyhow : )sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment