coalesce alternative in Access SQL August 22, 2023 by Tarik If it’s in an Access query, you can try this: "Price = IIf([Price] Is Null,0,[Price])"