how to order by - alphanumeric

• muthukrishnan.e

  SSC Enthusiast

  Points: 154

  More actions

  February 13, 2009 at 5:24 am

  #103684

  how to order by - alphanumeric

  Example:

  Input:

  L1

  L2

  L3

  L5

  L7

  L6

  L8

  L4

  Output:

  L1

  L2

  L3

  L4

  L5

  L6

  L7

  L8

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  February 13, 2009 at 7:02 am

  #943540

  SQL orders alpha-numeric just fine normally.

  [font="Courier New"]SELECT 'L1'

  UNION ALL SELECT 'L2'

  UNION ALL SELECT 'L3'

  UNION ALL SELECT 'L5'

  UNION ALL SELECT 'L7'

  UNION ALL SELECT 'L6'

  UNION ALL SELECT 'L8'

  UNION ALL SELECT 'L4'

  ORDER BY 1[/font]