SELECT
     FISICA.CODIGO AS FISICA
    ,CASE
        WHEN CHARINDEX(';', EMAIL) = 0 THEN EMAIL
        ELSE SUBSTRING(EMAIL,1,CHARINDEX(';', EMAIL)-1)
     END COLLATE sql_latin1_general_cp1251_ci_as AS email
    ,'principal' AS tipo
    ,'' AS redirecionamento
    ,'' AS servidor

FROM
    SOPHIA.FISICA FISICA WITH(NOLOCK)