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