thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

that worked, it cleaned up the data from 5.50000000 to 5.5

but now when i run "select top 10 * from table order by price "

it shows me

x 9.9

x 9.9

instead of 10 +

??

any ideas?