NZ() equivilent for Oracle? Or passthroughs? 1

[CptCrusty1]

I'm looking for the Oracle equivilant of the NZ() function so that I can use it in a Passthrough to Oracle, OR, so that I can create a view in Oracle and call it in Access... either way... what does Oracle call NZ()?

I live to work and I work to live.

 

[Golom]

Coalesce?

 

[pjm]

Oracle syntax is NVL (maybenull, 0)
You can replace the 0 by whatever value you want if "maybenull" is null.

pjm