Hello,

I'm trying to simply trap and replace null values. I can't seem to find a function that would help me.

Is there a function that would do something like the NVL in Oracle or the IsNull in SQL Server?

Thanks.

JFS

I'm not completely clear on what you're trying to accomplish but you might check into the Coalesce(x,y) function which returns the first non null argument or Null if both arguments are null. Coalesce and Value are the same functions.