[ASP] Displaying Random Records

I’m stuck on what should be a simple task.
Let’s say I have a table with a field name of color. There are a few entries in this field.

I’m trying to display them randomly. So in basic terms when the user refreshes their browser a random record is displayed.

I though this would be in the SQL statement, but apparently it’s not from what i have read. In fact, people on the net make it sound like its very difficult.

What am I missing?

Thanks