What is the Datatype of that column?
> 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
> ________________________________________________
> See http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't post to the list quickly and you use Netscape to write mail.
>
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)