How Can I Replace NULL Values in Access SQL Like COALESCE in T-SQL?

An alternative to the COALESCE function in Access SQL

In Transact-SQL (T-SQL), the COALESCE function is used to return a non-NULL value when one or more of the supplied values ​​are NULL. However, with Access SQL, a different approach is required.

To achieve similar functionality in Access SQL, you can use the IIf function. The syntax for using IIf in this context is:

<code>"表达式 = IIf([表达式] Is Null, NULL 值, 非NULL 值)"</code>

For example, to replace NULL values ​​in the Price column with 0, you can use the following query:

<code>SELECT ProductId, IIf([Price] Is Null, 0, [Price]) AS NonNullPrice
FROM Products</code>

This query returns ProductId and a new column NonNullPrice, which contains the actual price (if non-NULL) or 0 (if price is NULL).

This approach effectively emulates the COALESCE function, ensuring that no NULL values ​​are returned in the required columns.

The above is the detailed content of How Can I Replace NULL Values in Access SQL Like COALESCE in T-SQL?. For more information, please follow other related articles on the PHP Chinese website!