Query to select record sorted by last name

• RCRock

  Right there with Babe

  Points: 718

  More actions

  November 13, 2008 at 7:06 am

  #94093

  I have a table "Employee" with only one column "NAME".

  Entries are like

  "Ramesh Singh"

  "M Robert"

  "S Chand" ... and so on.

  Write a select statement to list completename -- sorted by Lastname (Singh,Robert,Chand)

• SwePeso

  SSC-Dedicated

  Points: 39752

  More actions

  November 13, 2008 at 7:11 am

  #898060

  SELECT *

  FROM Employees

  ORDER BY PARSENAME(REPLACE(Name, ' ', '.'), 1)

  ---

  N 56°04'39.16"
  E 12°55'05.25"

• RCRock

  Right there with Babe

  Points: 718

  More actions

  November 13, 2008 at 7:24 am

  #898073

  Thank you very much..its giving me desired result.:)