sql statement (order by)

[Mike]

A bit off topic, but I thought someone could
throw it out quick:

I have a select statement that grabs a bunch of
info from one table. One column has numbers
in it representing Potential Revenue. I am trying
to order my query by this column but I do not get the results
i want. The order by just orders it by the first number.

For instance

10
1000
20
2

I want 1000 to be first and then descend from there.

I have done this before but it is quite a bit like
forgeting how to spell "the"!


v/r
Mike