Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    7

    Angry Unanswered: 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 & regards

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: ORDER BY using a list of elements

    How about a CASE statement?

    PHP Code:
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •