Re^2: sorta sorting fun

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

Comment on Re^2: sorta sorting fun

Replies are listed 'Best First'.
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]