select * from myquery order by lastname
Profile Image
<cfif preferredname neq ''>#preferredname# Photo<cfelse>#firstname# #lastname# Photo</cfif>
Name
#preferredname##firstname# #lastname#
Degree
#preferreddegree#
Primary Department
#primarydepartment#
Joint Department
#jointdepartment#