Rounding Number

I had to do something similar in sql and I came up with a sort of cheesy way of doing it (Converting from one variable type to another in isql). There may be an elegant solution out there somewhere (this isn't it). 1) Create a table with the data types you want to end up with. 2) Your first select statement can update from your original table to this new table, OR you can unload it to a file and reload it the new table. Puttng it into the new table automatically changes the data type. Rounding occurs automatically. (I've just used unloading and loading for this.) 3) Then you just unload from this new table over to your other database. I hope this helps you! Cathy Kipp ckipp@vth1.vth.colostate.edu Systems Analyst Colorado State University, Veterinary Teaching Hospital.