|
Can you not ORDER BY SUBSTRING(Name FROM LOCATE(' ',Name)) or similar? (I'm aware that this includes the space).
I don't have an SQL set up to see if that would work but might be worth a try. Alternatively ORDER BY SUBSTRING(Name, LOCATE(' ',Name)).
__________________
I can't understand why people are frightened of new ideas. I'm frightened of the old ones. -- John Cage (1912 - 1992)
|