---
title: "Discussion on \"Demystifying the coalesce function\" | Hashnode"
description: "Discussion on \"Demystifying the coalesce function\". Coalesce() is a one of those functions that might not strike you as being very useful, mainly because it doesn't sound very exciting. But it IS useful, and might save you some time and complexity \nWhat does coalesce mean? In the English language, it ..."
url: "https://hashnode.com/posts/demystifying-the-coalesce-function/5fd523f6f60e3973bae6b9ab"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Demystifying the coalesce function](https://johnmackintosh.hashnode.dev/demystifying-the-coalesce-function?utm_source=hashnode&utm_medium=feed)

Coalesce() is a one of those functions that might not strike you as being very useful, mainly because it doesn't sound very exciting. But it IS useful, and might save you some time and complexity What does coalesce mean? In the English language, it ...

Dec 12, 2020 · 4 min read · johnmackintosh.hashnode.dev  
Updated Jul 28, 2021  
Read the article

-   [#r](https://hashnode.com/tag/r)
-   [#sql](https://hashnode.com/tag/sql)
-   [#sql-server](https://hashnode.com/tag/sql-server)
-   [#data-science](https://hashnode.com/tag/data-science)
-   [#databases](https://hashnode.com/tag/databases)

## Written by

[John MacKintosh](https://hashnode.com/@johnmackintosh)

@johnmackintosh · Inverness, Scotland

  
[View profile](https://hashnode.com/@johnmackintosh)

R, SQL, and data science

Experienced data analyst, blogger and online instructor. Based in the Scottish Highlands, I am an avid R user, and enjoy sharing my learning as I discover new packages, tools and techniques. I am a fellow of the NHS-R community, have developed some R packages, and my blog posts regularly appear in the R-Weekly roundup. I also have a decade of SQL experience and have a popular SQL course on a leading online data science platform

## Responses 1

Markdown supported · ⌘↵ to post

[Paul Apivat](https://hashnode.com/@PaulApivat)

[Dec 18, 2020](https://hashnode.com/posts/demystifying-the-coalesce-function/5fd523f6f60e3973bae6b9ab/comment/5fdc0e8a1485f22e24b32b4c)

I wasn't familiar with coalesce(), glad to learn something new :)
