I have a list of records but there comes a time when I wish to swap records around; is there a way of doing this in ASP?

Can you elaborate just a wee bit?

Oops sorry.

I have 4 records in a database
A - James,
B - Darren,
C - Emma &
D - Anne.
Is there a way of swapping the records (and all the info) of B & C?

I realise I can get the data in any order but I would like the option of swapping data.

Well, there's no relevance to a record's row position in a database. If you have them lettered or numbered with a column like you show here, you could just swap the letters or numbers with each other and then re-sort the recordset. Depending on how fancy you want to get, that could just be a matter of using input boxes and a pushbutton, or using jscript to do that for you. You'd save changes to the recordset, and post the form back to the same page.
There may be other ways of doing this. I would suggest you post the question to www.aspmessageboard.com.