Sorting Data on Web Pages

[Mepurathu]

Hi;
I am kind of new to the Web and I would like to know how to sort records on the web page.
For example, if we have some addresses displays on the ASP Page and if we would like to sort them in different order; How can it be done? When we do this, "Does it make another trip to the Server/Database? If we can get the recordset as XML data, Is there any Advantage?"

thanks
Jacob

[chrisjk]

When getting the data from the database append 'ORDER BY fieldname ' then either leave blank for ascending or enter DESC for descending to your SQL statement