Order Query by Number only reads first number .

[inzition]

I have a result page which has price lists, but for some reason the code cannot distinguish between 25,000 and 5,000.

Another words in a DESC price result, i get:

80,000
78,000
72,000
6,000
52,000
42,000

It reads the first number, and if first number is the same it reads second, but how do i get it to Order by the entire Number?

[devinemke]

what field type are you using? it looks like you are not using an INTEGER type. that might explain the problem.