What to use in place of COALESCE?

[jwest]

Does the version of SQL supported by MS Access 2002 supply a function similar to COALESCE as available in MS SQL Server?

Thanks in advance!

Jack

 

[RV]

No.
We're talking 'bout two different products.

Perhaps here you can find a way to create a similar user defined function in Access:

http://www.sqlmag.com/

RV

 

[ritchieroo]

Nz function

Syntax: Nz(Value, [ValueIfNull])

(built-in function)

 

[jwest]

Perfect, Thanks!

Just what I was looking for!