SQL CASE Anweisung

[B.Hauser]

Versuch's mal so:

With x as (select Cast(substr(feld, 57, 9) as Dec(9, 2)) Fld, a.* 
             from Wert a)
Select Fld Summe, 
      Case When Fld < 0 then Fld else 0 end as Negativ_Summe,
      Case When Fld >= 0 Then Fld Else 0 End as Positiv_Summe
From x;

Birgitta

[Bobou]

Vielen Dank für die Hilfe, funktioniert beides wunderbar

Gruß
Bobou