Tilted Forum Project Discussion Community - View Single Post

Moskie · 04-20-2004, 05:18 AM

My solution was:

Code:

SELECT Name FROM Employee ORDER BY MID(Name,INSTR(Name, ' ')+1)

INSTR returns the index of the first space in Name. Using that index, I use MID to get everything after that location, which is the last name. ORDER BY that result, and you got it sorted.

I'm not sure how you'd do this on a different (non-MSAccess) database, but I think most databases have equivalent functions to use.

04-20-2004, 05:18 AM	#7 (permalink)
Moskie Pure Chewing Satisfaction Location: can i use bbcode [i]here[/i]?	My solution was: Code: SELECT Name FROM Employee ORDER BY MID(Name,INSTR(Name, ' ')+1) INSTR returns the index of the first space in Name. Using that index, I use MID to get everything after that location, which is the last name. ORDER BY that result, and you got it sorted. I'm not sure how you'd do this on a different (non-MSAccess) database, but I think most databases have equivalent functions to use. __________________ Greetings and salutations.