Sort Order

• suresh0534

  SSCommitted

  Points: 1966

  More actions

  April 18, 2014 at 3:52 pm

  #148388

  Hi,

  I have one column in table like code.

  The table contains data like:

  01

  02

  03

  04

  05

  04A

  05A

  06

  I need to sort that data in ASC order: out put should be like:

  01

  02

  03

  04

  04A

  05

  05A

  06

• LutzM

  SSC Guru

  Points: 107049

  More actions

  April 18, 2014 at 4:11 pm

  #1707211

  Something like this?

  SELECT [one column] FROM table ORDER BY [one column]

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]