Ordering an SQL statement

[moo]

I have a table with columns called username and page_name. The columns look like this:

Username Page_Name
dave algarve 09/09/00
dave algarve 09/08/00
dave algarve 08/10/00
dave algarve 07/00/00

As you can see the page_name is not in order of descending order (08/10/00) should be at the top. The field is not a date field it is a varchar. Is there any way I can order this. There is also another column in this table called url_extension which would be algarve090900.shtml for Algarve 09/09/00 if it would be easier to order by this column. [sig][/sig]

 

[MikeLacey]

split the column you want to sort on using substr

then you can order it anyway you want

what database are you using? [sig]<p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br> [/sig]