I have several columns that I am trying to hold their precisions to
xxx.x. I originally had the column's types set as floats but kept
getting 0.xxxxxxxxx. I read that if you change the type to
numeric(9,2) you will get xxxxxxxxx.xx. I use sql explorer to view
the table setup and when I chage the type to numeric(9,2) and then
apply the changes, it changes to the type integer(4,1). This
effectivly rounds all of my results to the nearest integer x. I am
not sure what else to try????

Any help would be appreciated.

Greg