create or replace view tv_parbaduenc as
 SELECT p."PartnerArt",
        p."PartnerBundesland",
        p."PartnerName",
        p."VpNr",
        p.version,
        p."countryCode"
   FROM "Partner" p
  WHERE p."PartnerName"{{double_colons}}text ~~ concat('%', chr(65533), '%')