Weitere Formelbeispiele: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(Die Seite wurde neu angelegt: „=Schularten anpassen= ==BBS== 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%' THE…“) |
(→BBS) |
||
| Zeile 1: | Zeile 1: | ||
=Schularten anpassen= | =Schularten anpassen= | ||
==BBS== | ==BBS== | ||
* Spaltenname "D" anpassen! | |||
CASE | CASE | ||
WHEN D like 'BGY%' THEN 'BBS' | WHEN D like 'BGY%' THEN 'BBS' | ||
Version vom 9. April 2024, 07:32 Uhr
Schularten anpassen
BBS
- 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