ORDER BY using a list of elements

Hi,
I have to order a select in a special way, just using the name of the product. Can I use a list of the names of the products to do the ordering?
like "product 1", product 3", "product 5", "product 2", "product 4"...
The list of the products it's not so large and I could write them in a simple sentence. I'm working with Microsoft SQL Server 2000.

Thanks & regardsHow about a CASE statement?

ORDER BY
CASE WHEN name='product 1' THEN 1
WHEN name='product 3' THEN 2
...
END;

Or, perhaps better, add a new column like PRODUCT_PRIORITY to the table and order by that.