Weitere Formelbeispiele

Schularten anpassen

BBS

Schulart zu BBS zusammenfassen:

• Spaltenname "D" anpassen!

  CASE
       WHEN D like 'BGY%' THEN 'BBS'
       WHEN D like 'BS/BS%' THEN 'BBS'
       WHEN D like 'BS/BGJ%' THEN 'BBS'
       WHEN D like 'BS/gBVJ%' THEN 'BBS'
       WHEN D like 'BS-F/BS (v)%' THEN 'BBS'
       WHEN D like 'BFS/BFS (v)%' THEN 'BBS'
       WHEN D like 'BFS/BFS (t)%' THEN 'BBS'
       WHEN D like 'FS/FS (v)%' THEN 'BBS'
       WHEN D like 'FS/FS (t)%' THEN 'BBS'
       WHEN D like 'FOS/FOS%' THEN 'BBS'
       WHEN D like 'BS-F/kBVJ%' THEN 'BBS'
       WHEN D like 'BS/BVJ%' THEN 'BBS'
       WHEN D like 'BS/VK%' THEN 'BBS'
       WHEN D like 'BS-F/BvB%' THEN 'BBS'
       WHEN D like 'BS/BvB%' THEN 'BBS'
       WHEN D like 'BS-F/BS%' THEN 'BBS'
       WHEN D like 'BS-F/BVJ%' THEN 'BBS'
       END