Auf Thema antworten

Hab es nun mit TRIM gelöst

[CODE=sql]case when epi_season is Null then

      case when sub_shorttext is Null then '' else

        case when REGEXP_INSTR(sub_shorttext, 'S[0-9]+ ') = 0 then '' else

          concat('||Staffel: ', TRIM(LEADING '0' FROM TRIM(LEADING 'S' FROM REGEXP_SUBSTR(sub_shorttext, 'S[0-9]+')))) end end

    else

      concat('||Staffel: ', cast(epi_season as char)) end,[/CODE]