[Solved] Condition statement in a select

Select X, Y, NVL(Z, showThis) as Z

will return showThis if Z is null in ORACLE

Select X, Y, ISNULL(Z, showThis) as Z

will return showThis if Z is null in SQL-SERVER