ALTER TABLE `SUBJEKTY`
MODIFY COLUMN `CELE_JMENO` VARCHAR(255) GENERATED ALWAYS AS (
    CASE
        WHEN `PRIJMENI` > '' OR `JMENO` > ''
        THEN TRIM(CONCAT_WS(' ', `PRIJMENI`, `JMENO`))
        ELSE TRIM(`NAZEV_SPOLECNOSTI`)
    END
) STORED
COMMENT '..automaticky generováno ..';



