Firebird DB - need to update column values
Posted on 2007-11-27
Due to a messy import of data from another database we need an SQL statement with Firebird syntax that will update the numeric values in entire columns of specific tables by rounding to two decimal places. I am using Database Workbench to access the database, but don't know the proper SQL command / script to run to adjust the values as stated above. I also know that there are a probably a dozen post here that could help me, but I don't have time to keep looking for them.
I have table called JOBS, with columns called COST, AVGCOST, ESTCOST to name a few.