[thelist] SQL Order By Clause

Michele Foster michele at wordpro.on.ca
Wed Jul 25 18:30:10 CDT 2001


Hi Folks ....

Here's the outcome ..

http://ceramic.on.ca/print_all.asp

I would like to order the Item No. column in numerical order, such as
1,2,3,4 instead of the order it is in now, 1, 10, 100, etc.  This field is
text (see the end, text entries).

Is this possible, or am I SOL?

I've searched google and can't seem to find the correct syntax for
additional OrderBy clauses aside from ASC and DESC.  I know its been
mentioned in the past briefly.  Anyone have a good reference that lists the
different variables that can be used, and how to use them?

TIA,

Michele

___________________________

Michele Foster
WordPro Services
Aurora, Ontario, Canada
mailto:michele at wordpro.on.ca
http://wordpro.on.ca/






More information about the thelist mailing list