Re: sorta sorting fun

That simply shows that they don't know SQL. There's no particular trick to it.

select FName, LName, MName, Surname
from TABLE
order by substring(MName,1,1),
         substring(FName,2,1),
         substring(LName,datalength(LName),1)
[download]

This is with MS SQL. It should work on other SQL servers, though the functions may be different...

...roboticus

Comment on Re: sorta sorting fun Download Code

Replies are listed 'Best First'.
Re^2: sorta sorting fun by softworkz (Monk) on Feb 08, 2008 at 16:41 UTC
++Excellent help!! Thanks!! ++ for the example using MySQL	[reply]
Re^3: sorta sorting fun by softworkz (Monk) on Feb 08, 2008 at 21:29 UTC
Thanks everyone! Here's an example using Sql in Access SELECT MEMBERS.FNAME, MEMBERS.LNAME, MEMBERS.MNAME, MEMBERS.SNAME, Mid(FNAME,2,1) AS Expr1, Right(LNAME,1) AS Expr2 FROM MEMBERS ORDER BY MNAME, Mid(FNAME,2,1), Right(LNAME,1);	[reply]

In Section Seekers of Perl Wisdom