Re^3: sorta sorting fun

[softworkz]

in reply to Re^2: sorta sorting fun
in thread sorta sorting fun

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