You guys are the best!

I needed to do something similar and was stumped. So I cruised the Forum - found this example - and now am off to the...

Interesting, but my options are limited. I cannot change the structure of the table and I do not want to change much of the web pages. The numbers...

You guys are good!

The datafield is specified by Pivotal as currency, but in sql the datafield is a Float length=8 precision=15. If I use sql to change it to...

Hi,

I tried:

update tableA

set field1 = cast(field1 as decimal(38, 2))

where field1 is not null

and it did not work, the data is still stored 1.00000000001

To make a short story long, the reason...

Thanks,

I asked my question incorrectly. What I would like to do is change the data in the database to only store 2 decimals (from 1.000000001 to 1.00). I...

THANKS EVERYONE!!!

It was nice to have different options to choose from and pick the one that worked best for my situation.

Bill