sorting selected data

[tiger66]

Hello
I am just wondering how can I write a sql statment that sort the selected data in asc or desc order

Thanks

[khaki]

hi tiger...

you pretty much have it already

SELECT * FROM table ORDER by field_name DESC

or

SELECT * FROM table ORDER by field_name ASC

;) k