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