1 Replies - 930 Views - Last Post: 12 December 2008 - 06:11 AM Rate Topic: -----

#1 kensington  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 39
  • Joined: 08-October 07

Split and sort by lastname

Post icon  Posted 11 December 2008 - 06:56 PM

I have a field called fullname that outputs records with fullname of people.
Here is what I have when I do this sql:
Select fullname from tableOne;
John Jones
Bill Aronsen
Sam Baker
George Williams
Dave Smith



I would like to sort in order of last name but cant figure out how to do the sql:
Bill Aronsen
Sam Baker
John Jones
Dave Smith
George Williams



Please advise.

Is This A Good Question/Topic? 0
  • +

Replies To: Split and sort by lastname

#2 P4L  Icon User is offline

  • Your worst nightmare
  • member icon

Reputation: 34
  • View blog
  • Posts: 2,788
  • Joined: 07-February 08

Re: Split and sort by lastname

Posted 12 December 2008 - 06:11 AM

One question, is recreating the table with the last name and first name split out an option?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1