ASP and SQL: Randomise?

[tonytryout]

I am doing a database on football (soccer) and contains several tables like LeagueTeam, LeagueTeam_1, Event, Player, Squad, etc...

I am wondering if there is a chance of randomising the fixture list? e.g.
1. LeagueTeam (for home team)
2. LeagueTeam_1 (for away team)

1. Newcastle V 2. Sunderland
1. Man Utd V 2. Liverpool
1. Sunderland V 2. Liverpool
1. Sunderland V 2. Newcastle
1. Newcastle V 2. Man Utd
1. Liverpool V 2. Newcastle

etc..
These fixtures would be stored in a table called Fixtures.

What are the procedures in randomising the League Teams (on ASP side not database) and producing a page containing the randomised fixture?

Help/advice would be greatly appreciated.

[tonytryout]

Hate to do this but <bump>