[RESOLVED] Equivalent of Nz() Function

[techgnome]

Instead of nested IIFs, try using COALESCE() - it returns the first non-null value. Or handle the null check in your C# code. Either should work in ADO.NET.

That's what I thought...

but...

Nope, Coalesce isn't a recognized function.

What's annoying is that Nz is recognized in Access, but apparently not in OLEDB ADO.Net, while IsNull is used in the fashion that it works in Access, but not in the fashion it is used in SQL Server. Meanwhile, Coalesce isn't there at all.

Which I don't get because it shoul;d be a SQL function...