decimal places

I have many columns of data. They are all using the money datatype. When I
enter a value into a column such as 32.00, it only shows up as 32. When
outputted to an ASP page using a query it also only displays 32. If the
data is 32.33, then the display is 32.33. How do I get it to display 32.00?
Thanks!

Darren
MCPI also want to format the numbers with a comma for thousands in some
calculated fields! Thanks

Darren
MCP

"Scrappy" <celtics@.lan-specialist.com> wrote in message
news:vUNyb.153675$1N3.77976@.twister.nyroc.rr.com.. .
> I have many columns of data. They are all using the money datatype. When
I
> enter a value into a column such as 32.00, it only shows up as 32. When
> outputted to an ASP page using a query it also only displays 32. If the
> data is 32.33, then the display is 32.33. How do I get it to display
32.00?
> Thanks!
> Darren
> MCP|||See
http://groups.google.com/groups?sel...8&output=gplain

Gert-Jan

Scrappy wrote:
> I also want to format the numbers with a comma for thousands in some
> calculated fields! Thanks
> Darren
> MCP
> "Scrappy" <celtics@.lan-specialist.com> wrote in message
> news:vUNyb.153675$1N3.77976@.twister.nyroc.rr.com.. .
> > I have many columns of data. They are all using the money datatype. When
> I
> > enter a value into a column such as 32.00, it only shows up as 32. When
> > outputted to an ASP page using a query it also only displays 32. If the
> > data is 32.33, then the display is 32.33. How do I get it to display
> 32.00?
> > Thanks!
> > Darren
> > MCP|||"Scrappy" <celtics@.lan-specialist.com> wrote in message
news:rhOyb.154023$1N3.102544@.twister.nyroc.rr.com. ..
> I also want to format the numbers with a comma for thousands in some
> calculated fields! Thanks

You don't. Formatting is best done in the display layer, not the storage
layer.

> Darren
> MCP
> "Scrappy" <celtics@.lan-specialist.com> wrote in message
> news:vUNyb.153675$1N3.77976@.twister.nyroc.rr.com.. .
> > I have many columns of data. They are all using the money datatype.
When
> I
> > enter a value into a column such as 32.00, it only shows up as 32. When
> > outputted to an ASP page using a query it also only displays 32. If the
> > data is 32.33, then the display is 32.33. How do I get it to display
> 32.00?
> > Thanks!
> > Darren
> > MCP