IIF ... CASE
f.bla AS S_Bla,
(
CASE TO_CHAR(Reparaturdatum, 'YYYY')
WHEN '1899'
THEN '-'
ELSE TO_CHAR(Reparaturdatum, 'DD.MM.YYYY')
END) AS S_RDatum,
f.Fallzaehler AS S_Fallzaehler,
NZ ... NVL
No comments:
Post a Comment