Re^2: sorta sorting fun

[softworkz]

++Excellent help!! Thanks!! ++ for the example using MySQL

[softworkz]

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);