可以在SQL Server和MS Access中使用的COALESCE，IFNULL或NZ（）函数

I have a project that can use either SQL Server or MS Access as the data store. In one SELECT statement, I must perform a COALESCE operation on a single column and a single value, like this:I have a project that can use either SQL Server