|
1 2 3 4 5 6 7 8 9 10 11 12 |
CONSTANTS: lc_scary1 TYPE STRING VALUE 'SLIGHTLY SCARY', lc_scary2 TYPE STRING VALUE 'REALLY SCARY', lc_scary3 TYPE STRING VALUE 'NORMAL'. SELECT monster_name, monster_number CASE WHEN sanity <= 10 AND strength >= 75 THEN @lc_scary2 WHEN sanity <= 25 AND strength >= 50 THEN @lc_scary1 ELSE @lc_scary3 END AS scariness_string FROM zt_monsters WHERE monster_number = @ld_monster_number INTO CORRESPONDING FIELDS OF @lt_monsters. |
