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.