though I actually need to add spaces when the name is in there. Actual formula:

(CASE WHEN {firstname} IS NOT NULL THEN {firstname} || ' ' ELSE '' END) || (CASE WHEN {middlename} IS NOT NULL THEN {middlename} || ' ' ELSE '' END) || (CASE WHEN {lastname} IS NOT NULL THEN {lastname} || ' ' ELSE '' END)