Here is my sql:

select
ResFirst, Reslast, '<a href="mailto:'||eMail||'">'||ResLast||'</a>' as eLast,
Nickname, Bldg, Unit, Cell, Landline, Birthday from Residents
Order by ResLast, ResFirst

<...> is html to include link to the person's email address.

Works fine, but I want to omit ResLast from the result set.

eLast also contains the last name. I cannot sort on that because the entire string is sorted, not just the last name, which is the desired sorting.

Any ideas?