How do I arrange my tables information in alphabetical order

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • JnrJnr
    New Member
    • Oct 2009
    • 88

    How do I arrange my tables information in alphabetical order

    Hi, Im trying to arrange my table's information alphabetically.
    Say I have a table with a list of countries that I inserted randomly and now want them to be arranged alphabetically. Can I do this to the tables data itself without using the
    Code:
    Select Country from table, ORDER BY COUNTRY
    statement to just retrieve the data?

    thanks in advance
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    Yes. Read BOL about CLUSTERED INDEX...

    Good Luck!!!

    ~~ CK

    Comment

    Working...