select concat_ws(" ",FName,LName) as Name, Title from board where (Status="current") and (Trim(Title)<>"") order by Sort asc, LName asc select concat_ws(" ",FName,LName) as Name, Title from board where (Status="current") and (Trim(Title)="" || Title is NULL) order by Sort asc, LName asc select concat_ws(" ",FName,LName) as Name, Title from board where (Status="emeritus") order by Sort asc, LName asc

|
Board of Directors
|
|||||||
|
Officers
Members
Board Emeritus
|
||||||||