UPDATE SERVICE_ENTRY s SET HOME_DIRECTORY = (SELECT CONCAT('\\\\areas\\home\\', (SUBSTRING(s.EXTERNAL_ID, 1, 1)), '\\', (TRIM(TRAILING '@iscte.pt' FROM s.EXTERNAL_ID)))) where OJB_CONCRETE_CLASS = 'net.sourceforge.fenixedu.domain.externalServices.LdapServiceEntry';
