when i run

select * from table order by price asc

i get...

115.50

36.00

4.95

4.95

4.95

47.30

49.50

49.50

53.90

when i should get

4.95

4.95

4.95

36.00

47.30

49.50

49.50

53.90

115.50

what do i need to change in the sql query ?

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...

i ran "update table set price = price * cast(1.1 as numeric(10,4))" and that worked pretty well

thanks! 🙂

the value of the price field is:

.05

.25

.6

1

1.25

150.7

250

265.75

etc

so if there are no items price that are greater than $1000 then i would use the following: ?

update field set price = price...