delphi programming forums mysql charset mget recursive synonimos
free ventrilo servers hosting cs javascript delay python find in list
Back Forum New

Rank: 1
1# Jump to »
evergreanPost at 2010-6-27 03:20 | Show This Author's Posts Only
abstract:

I would like to sort in order of last name but cant figure out how to do the sql:
Code:

Bill Aronsen
Sam Baker
John Jones
Dave Smith
George Williams
Please advise.


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;
Code:
  1. John Jones
  2. Bill Aronsen
  3. Sam Baker
  4. George Williams
  5. Dave Smith
Copy Code
I would like to sort in order of last name but cant figure out how to do the sql:
Code:
  1. Bill Aronsen
  2. Sam Baker
  3. John Jones
  4. Dave Smith
  5. George Williams
Copy Code
Please advise.

TOP

Rank: 1
2#
EbotPost at 2010-6-27 03:20 | Show This Author's Posts Only
well, you are going to have to usre substr() to get the last name from the column and then sort by that value.



I would like to sort in order of last name but cant figure out how to do the sql:
Code:

Bill Aronsen
Sam Baker
John Jones
Dave Smith
George Williams
Please advise.

TOP

Back Forum