Используйте:
TRIM(value)
Например в запросе (вместе с конкатенацией):
SELECT CONCAT(TRIM(surname), ' ', TRIM(io)) as FIO, phone, email, work_place_name as workPlaceName_or_ProductName FROM Nominee ORDER BY fio;