Short answer: kinda depends on what you’re doing and if appropriate. I use COALESCE(SUM(Table.Column),0) sometimes and works just fine.
With the brief amount of information here hard to say if this would work in whatever scenario you are attempting. Check this out: Tips for asking a question on the forum
EDIT: Try this link see if it helps: COALESCE (Transact-SQL) - SQL Server | Microsoft Learn