Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

You can use COALESCE to use the first non null field:

SELECT CONCAT(`SurName`, ', ', COALESCE(`FirstName`,'')) AS `FullName`,`MemberID` FROM `Members`